Recent content by austinr

Any Ideas?

I am creating a form that includes an add and delete button on the form. I have two other databases that these buttons work with. Using the same VB code (and name of the button) in my current database gives me the following error: "The express On Click you entered as the event property...

I was doing something similar. Microsoft offers a quick tutorial here: http://office.microsoft.com/en-us/assistance/HA011878561033.aspx Hope that helps!

I have been doing something similar. I found the following post to be very helpful:http://www.access-programmers.co.uk/forums/showthread.php?t=99353&highlight=search

Well, I've found a solution to the issue that I was having. Apparently, if you have a combo box on the main form, the subform does not communicate with it to display information. However, if you hide the field somewhere on the form, the combo box will communicate with both the field and the...

Yes, I have it set to data entry and I realize that it will not show any information. I would like the those entering data to not be able to change other records; however, I would like the subform to display information that corresponds to information that the data entry person may be entering...

I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information. Ideally, I would like them to display information when the field linked to the subform is entered on the main...

Thanks, I'll look into it.

Currently I have three separate forms that correspond to three separate tables. The three tables cannot be combined. Is there a way to have a form write information to multiple tables depending on the field? Any help is appreciated. Thanks.

Well, I figured it out. I believe that the name of the text box was the main problem. However, Access for some reason modified the code to read : =[Format$]([Next_Date],"mmmm yyyy",0,0) instead of: =Format$([Next_Date],"mmmm yyyy",0,0) This was the source of the #Error. Thanks again for...

Thanks for the help. I changed the text box name and I no longer recieve the #Name?; however, I now recieve a plain #Error. When I run the report, it asks me to "Enter a Parameter Value for Format$" Any Ideas on this? All help is appreciated. Thanks in advance.

I'm attempting to generate a report in access using the provided wizard. I am trying to sort the report based on a date so that it is subdivided into months/years. The wizard generates the following code: =Format$([Next_Date],"mmmm yyyy",0,0) When I preview the report, a "#Name?" error...

Thanks for the help! The union query is exactly what i needed.

I'm in the process of learning to use Access and I would appreciate any help that can be provided. The problem that I am facing is that I have data in three different columns, and this cannot be changed. The database that I am creating links to another database to retrieve a table. This table...