Help

Concatenate 3 lines of text into a "Paragraph"
I have three lines of text I need to concatenate into one "paragraph". The "paragraph" need to look like: Text1 Text2 Text3 where the lines of text are stacked in the "paragraph". When I use three textboxes, there are definite breaks between Text1 and Text2 and Text2 and Text3. I tried one textbox and set the... 12 Sep 2005 03:17

Payroll DB
Hi all, New to Access...... Trying to create a payroll database for employees who are paid on the 1st and the 15th of the month. This is quite different than every 2 week pay periods. Employees work all hours of the day, any day of the week, depending on their assignment, and this can change from day to day. ... 6 Sep 2005 18:14

Access hanging periodically
Every few minutes, my access program hangs for about 5 seconds. I have a strong feeling that this is happening while the program is saving my work in the background, but I can't understand the reason it hangs. Any leads I can pursue to fix this problem? How can I disable to autosave feature of access whi... 6 Sep 2005 07:21

Does ACCESS have the MINUS keyword
ACCESS says there is a syntax error in this statement. I am trying to find out which records are not in the second table. SELECT Charges.ID, Charges.Total FROM Charges MINUS SELECT Invoice_Details.ChargeID AS ID, Invoice_Details.Amount As Total FROM Invoice_Details; Can I do this in Access? If not, is the... 4 Sep 2005 01:42

dirDataCopy error message when converting to Access 2000
Hello, I created an Access database in Access 2002-2003 that I am trying to convert to Access 2000. During conversion, I get error "The report name ' dirDataCopy' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exit." I click 'ok', the word 'Converting' stays on... 3 Sep 2005 10:54

Concatenating text fields with a WHERE condition
I have a problem using Dev Ashish's excellent module to concatenate the results of a field from several records into one record. I am using the code to concatenate certain awards onto a certificate at the end of the year. I have the code working fine, except for the fact that when I want to restrict the entri... 17 Sep 2005 10:39

Elookup vs Dlookup, Error 3048
I have read with interest the many discussions of the 3048 Error: Cannot open any more databases. I understand how the number of open Table ID's causes the problem. My question has to do with the usage of the Elookup routine as a substitute for Dlookup. I read that Dlookup 'does not clean up after itself'. Most of... 29 Aug 2005 22:40

postcode finder, lookup,search
If anyone is looking for a cost effective postcode finder try this http://www.postcodeanywhere.co.uk/ it is brilliant and very easy to use ... 21 Sep 2005 10:29

multiple contition field in a query
How can a query display multiple fields with diferent condition on the same field example I have a field name of reason and a field name of duration. I would like to display 2 fileds of total duration but each have different reasion criteria. display Total Recall based on a calculation that adds the total du... 6 Jul 2005 13:06

Can't open query in SQL View to correct query ("Join expression not supported")
I am using MS Access 2003, and I typed in a query in SQL view which was working fine. Now when I open it, it gives me the error "Join expression not supported". Apparently, Access "fixed" it for me. Unfortunately, I can't correct it because when I click "OK", the window disappears. I don't see any way to open th... 28 Jun 2005 16:03