Getting Started

Select Subquery Error
I copied this query from a post and modified table & field names: SELECT T.EmpID, (IIf([ClockIn]=True,"Clock In","Clock Out")) AS ClockType, (IIf([ClockIn]=True, Null, DateDiff("n",Nz( (SELECT Max(Q.[TimeStamp]) FROM TimeSheet AS Q WHERE Q.ClockIn = True AND Q.TimeStamp < T.[TimeStamp]),0), T.[TimeStamp]... 10 Jun 2008 10:28

Anuncie seu Carro ou moto
Anuncie seu Carro ou moto Vamos aproveitar enquanto � de gra�a, logo devem come�ar a cobrar... http://wwww.superfeirao.com.br ... 9 Jun 2008 14:29

Fixing an existing database
I'm a newbie, forgive me. I know just enough to get myself in trouble. I've designed a simple database for tracking pawn slips. My fields are: Last Name, First Name, Middle Name, Birthdate, Item Name, Item Description, Serial Number, Pawn Shop, Transaction Date, Amount, Transaction Number Now that I look at ... 9 Jun 2008 14:29

updating data from one table to insert into a scond table
I am relatively new to VBA and access. I have existing access tables that I use for invetory. I have a barcode system for tag # and I track coil inventory. What I need to do is query and paste coil data from a table or the form called NEW into a table called SLIT NEW. when I insert the data in the SLIT NEW tabl... 12 Jun 2008 18:59

Edit previously saved Field in a Form
Hi I want to be able to edit some or all fields which have previously been entered on a form. Records have been previously entered and saved by being typed in and/or selected on a form. When I select a particular CustomerID, I can view particular saved records, and I want to introduce the option to amend pa... 10 Jun 2008 08:25

Cummulative
How can I calculate a cummulative of: A = 4 B = 5 C = 8 ... 9 Jun 2008 11:55

won't take my product key
... 8 Jun 2008 21:32

Mail Merge Code Problem
I am new (I know next to nothing) to mail merges, but want to merge data in an Access select query with a word document. After much searching and copying and pasting and generally messing around, I finally came up with the following code which I run from the Access VB Editor: Function MergeLeaveSlips() Dim ... 21 Jun 2008 05:37

Create Command button to activate hyperlink ?
I am new to Access and cannot use VB quite yet. I am trying to create a command button in a form that when clicked will open a hperlink pointing to a document. I have the hyperlink in place and it works if I click on the hyperlink field itself but want to create a command button to do this. Can anyone direct... 8 Jun 2008 12:53

Information in sub form
I have 2 forms. Main form 1 and a sub form. I'm using 2 tables. Table 1 for the main form and table 2 for the sub form. Table 2 is a table with a memo field in it for instructions on how to Delete a Record or something else. Sub form 2 is a general form and I want to use it in other forms so I can give other in... 7 Jun 2008 07:45