Search results

Is it not possible to export or "save as" Access 2010 DB's in an earlier version? I'm trying to save as a 2007 file. Any advice? Thank you

This one is a bit difficult for me to figure and understand how to solve. Please keep in mind, I am doing all I describe below in effort to handle an "escape" by the user. If the user "escapes" I want to clear the form and close it which I can do fine with the error handler and the following...

Please help me understand! I have an unbound ComboBox which I am using to allow a user to select a record. On "click" the CB calls code so I can use the info in the combo box to populate text boxes in the form. Ok, it works great for a split second but as soon as I move to the next field of...

Will someone please tell me what the problem is in this DLookup statement? I keep getting a syntax error on the "Me.cboAsset_ID.Column(6)". answer = DLookup("[Issued_Quantity]", "Materials", "Material_ID = Me.cboAsset_ID.Column(6)")

Hi, I'm hoping someone can help me figure out how I can get these forms to reset or fields correctly. I have two forms that are opened in the "add" mode using the switch board: Form A: For some reason, if I press the escape key in the first field the form will not clear the first field but...

Finally got my DB straight so I am not using calculated fields however can't figure out the best way to handle the Combo Box so I do not show closed records ( Item checked out and item returned). Please see the attached table of materials checked out and materials returned. Will someone...

You all have been a great help and I Thank you but now I am not sure how to proceed. Please offer advice and perhaps code statements to help. Please allow me to explain: I have a parent table with two child relationships as follows: Parent: Material_Assigment Child: Materials Child...

I hope my experience will be of help to some people because now I am in over my head in a job that has taken three times longer then I ever expected. I was volunteered to create a DB which simply tracks the equipment at our facility and who the equipment is assigned to. I volunteered simply...

I have done this on another form and it is working great. I don't understand what the difference is and why it does not work? I have setup a ComboBox on a form, Listed the PK of the table as the control source. Inserted the PK and many other field as the row source. When I go to select a...

Can anyone help me figure out why am having problems writing to this textbox on my form? Textbox name is: Last_Name Text Control Source is :Last_Name Line of code is : Me.Last_Name = Me.Combo0.Column(4) I get the following data in the textbox " #Name?" and the error: " You cannot assign a...

For three days I have been trying to create a specific form and all the things I know simply do not work..........Please help I have a table of records (Table A) which has two tables or PK's from foreign tables embedded in it (Table B & Table C). I want to create a form which details the...

I have a simple form with 3 fields. I am having a problem as the form will not run the AfterUpdate event code triggered in the last field "Date_entered" I suspect the code of the first field "Material_ID" triggered by BeforeUpdate may be prematurely exiting the form??? I can continue entering...

Hello, my form is opened in "add" mode using a switchboard. The first field of the form calls a VB Sub which makes some necessary changes (based on user responses) in some foreign tables. If the user "escapes" while entering data in the 2nd or 3rd fields, of course after the VB module has...

I probably wouldn't ask this question if I didn't have a problem. I am testing text fields that are blank (I think are blank). The watch window shows the variable returned as "" However the IFisNull fails? At first this was all working and the test passed with "" returned. What has happened...

[Solved] Relationship error 3368 ? [Solved] I have done this many times and do not understand why I am getting this error "3368" From Access 2007. I am trying to relate the PK of a new single text field table named "manufacture" to an existing table of materials. Table materials does have...

Will someone please tell me where in Access 2010 I can modify the displayed fields of a Combo Box on a form. I need to format the display window and add criteria to one of the fields. Can't remember where I set this up and recently upgrading from Access 2007 isn't helping. Thank you Dale

Hi its been a while since of written in Basic....15 years. I am doing fairly well...having fun too, but can anyone point to a good source for researching code examples that gives good explanations and examples of statements and proper syntax.?

Would anyone be willing to help me debug my syntax? The below code statement test to see if an item has been marked "yes", Then checks the serial number is blank. If the serial number is blank will prompt for a number and write it to the record. I am getting a compile error and am sure it...

Switch Board "add new materials" not updating records Will someone please help me figure this out? Using the SB, I open a form in "add new items" criteria, Keep in mind, the form calls a VBA module. Upon returning form the module and completing the form, the SB or form does not record and...

Can someone tell me what happened to the Switch board in 2010. Has it been replaced by another feature? Thank you, Dale