Search results for query: *

Thanks Ed...unfortunately, that is a column name in our payroll system to denote a union employee, so I will just have to remember to use the [] in sql view whenever I use this column. I don't know why it worked in 2000 when perhaps it shouldn't have. That is why I was so frustrated when it...

Thanks Ed! You are correct, as I found out on my own. I tried each field from Table1 to isolate the problem and found that indeed it was the union field that was causing the problem. I figured that it confused the query because union is a sql term. I did this to solve it (to help sql understand...

I am getting the above error when I try to run this union query and I cannot find what's wrong with the sql: SELECT Mid(Table1.DEPT,2,2) AS STORE, Table1.DEPT, Table1.NAME, tbl_Accrual_Holidays.FILE, tbl_Accrual_Holidays.HOL, tbl_Accrual_Holidays.HOURS, tbl_Accrual_Holidays.DATE_ADDED...

yes!! that did it...very nice! Thank you so much for the help, Rey

Hello, I have been trying to think of a way to build a query that returns results and then numbers each result incrementally for the number of times the result is the same. For example, if I have two columns named "Employee#" and "Incident Date" and the results return employee number "1111" on...

thank you Alex and Golom...I will stick with my original plan of just linking to the tables. I appreciate the feedback! Rey

Hello, I have multiple Access databases that use many of the same data tables so I thought that it would be more efficient to delete the common tables in all the databases and create a single database to hold all of these common data tables and then just link to them in the other databases. My...

Okay...figured it out. I changed the priority of DAO reference to that higher than the reference to ActiveX...thank you very much for the code...it works exactly how I want it to. Rey

I pasted the sql and ran it in a select query and it works fine.

Yes, the field names are correct.

Thank you for your help--I appreciate the time and effort. I have a "run-time error 3061, too few parameters expected 2" when I run the code...any suggestions? I modified your code to Set rs = CurrentDb.OpenRecordset ("Select Format(GRID,'mm/dd') As ctlname, SYMBOL From qry_Attendance1") Do...

Hello, I have created a "calendar grid" on a subform in this way: I have 12 rows of unbound textboxes, 31 textboxes per row. The 12 rows correspond to 12 months and 31 textboxes per row represents up to 31 days in a month. I have named each unbound textbox as "01/01" for the first row first...

Thanks for the replies! It took some figuring out to get the code from Dev Ashish to work, but I got it to do exactly what I wanted. Much appreciation! Rey

Hello, I have a combo box (employer listing) that is populated by a table (tbl_EmployersDatabase) as the row source. I have the 'Limit To List' property set to 'No' so that if the employer is not found in (tbl_EmployersDatabase), you can simply add it by typing it directly in the combo box. I...

Isadore, THANK YOU!!! <<Caps used intentionally :)>> I did exactly as you recommended and followed conventional naming. I had to tweak the code a bit...well, actually, I used your method to get the ID# for the recordset and used DoCmd.GoToRecord to return the recordset: Private Sub...

Hello, I want to perform a database lookup and return a matching recordset from various fields. However, I need the matching recordset to be based on lookup values from 2 fields of data where the 2 are in the same row (recordset). (I have a form where the user enters both criteria in...

Jebry, Thank you so much for the help, I really appreciate it a lot!!! As my &quot;project&quot; comes along, I'll more than likely be posting a bit more questions. Rey

(Please excuse me if this is the wrong place to post this type of question--if there is a more appropriate place for this type of question, I would greatly appreciate being directed there. Thank you.) I am an MSAccess brand-newbie (who, by the way, is hard pressed to find any Access forums on...