Search results

"Name" is a text field, "FMLA_Yearly List" is a query, "FMLA_ID" is a number field I tried taking out the spaces where i thought they should be taken out and still no go. =DLookup("Name", "FMLA_Yearly List", "FMLA_ID = " & forms! FMLA Log! FMLA_ID)

I tried looking at that link before and still got error message says invalid syntax. This time i cut and pasted the names into the example and still no go :confused: DLookup("Name ", " FMLA_Yearly List ", " FMLA_ID = " & forms! FMLA Log! FMLA_ID)

I have several DLookups in my 2003 version that work fine, but when i upgrade the db to 2007 they do not work. Is the syntex different in 2007? Here is just an example of one of them used in a form. =DLookUp("[Name]","[FMLA_Yearly List]","[FMLA_ID]=[Forms]![FMLA Log]![FMLA_ID]") I search...

Thanks that worked perfect!

Thanks Galaxiom, I don't know what i would do without you guys :)

I am having a promblem with the DateSerial function and hope someone can help. Here is what i put in the criteria of the Hired Date <=DateSerial(Year(Date()-1),6,1) I need it to return all employees that were hired less then or equal to June 1, 2009 Instead it is including employees hired...

I tried this function for one of my queries and it didn't work. Could you take a look at it and let me know if you can see why it wouldn't work. Thanks Here is what i put in the criteria of the Hired Date <=DateSerial(Year(Date()-1),6,1) I need it to return all employees that were hired less...

Thats Bob that worked! However i didn't need all the ) at the end Very helpful!!!!

I need to create a query that will show me the list of Employees that were hired before June 1st of the current year. I have a field called Hired Date and tried to put something in the criteria for this field but nothing worked. example 06/01/Year(Date()) How do write it so it always looks for...

Not much of a programmer so i thought i would use the other approach. Still don't understand why i cannot see my custom toolbar in the Access Options. I looked in all 3 combo boxes in the Ribbon and Toolbar options.

Shadow, I tried the steps in accessjunkie.com link but I can not select my custom toolbar in the Menu Bar combo box, it does not appear in the list. However it still shows up in the Add-Inns tab. Any ideas why this would happen?

I have researched this and still can not get my custom toolbar that was created in 2003 to show up in 2007. I have hidden the ribbon and would like the custom toolbar to show up when viewing reports. Any suggestions?

Is there a way to turn off or hide the "Customize Quick Access Toolbar" down arrow that is beside the Quick Access Toolbar?

I did the same thing that SOS suggested but someone could still go to the "Customize Quick Access Toolbar" down arrow and select customized then undo all your changes. Is there a way to hide this as well?

How would one put a trigger on a field and then update? Not a SQL person, know Access very well...

Is this feature in SQL Server? I have a table were the ManufacturerID is the name of the company. Because this is the primary key, we are not able to change if there is a spelling error. In Access i can turn on the Cascade Update feature. Not sure if this can be done in SQL Server. Any suggestions?

Is there a way to print a report when there is no data? I have a report that has three subreports and if there is no record in one or more of the reports the report as a whole looks bad, leaving blank spaces. I would like to have the sub reports show the report and leave the data fields blank so...

I have a 2003 Database that tracks Employee data and the Primary Key in the Employee Table is SSN. On occassion i need to correct someones SSN and because it is a Primary Key this can only be done by turning on the Cascade Update feature. However I do not what to leave this turned on. So is it...

I sure feels stupid! I was forgetting the = sign, thanks everyone

That's fine, how do i leave the criteria section, i tried the following but it didn't work DLookup ("[fieldname]","[queryname]","") Thanks