Darcjohnson01
Last Activity: Mar 12 '15, 02:16 PM
Joined: Feb 26 '15
Location:
-
With the switchboard I do not see the code for the individual button or text associated with the button or either I do not know how to access the control. When I open the switchboard in design view I see one button and one text box item. Let me review the properties and maybe I will have more information to ask my question properly. Thanks -
I would like the button and the text to respond the same. Some forms I do want to open in form view and others I want to open in datasheet view.Leave a comment:
-
Access 2010 Input Box to Search Form
How do I create a search by three different field search options to bring up a record to revise that record based on what was searched for.
I.E. I have 20 fields (I want to search by Field 1, Field 2 or Field 3) bring up the record associated with the searched request (If I don't have information for Field 1, search by Field 2, if I don't have the information for either field 1 or field 2, search for field 3). Once the record is displayed... -
Access 2010 Switchboard Items
I've created a switchboard in Access 2010. When I click on the button to open a form it displays in datasheet view, when I click the text associated with the button (to the right of the button)it displays in form view.
How do I fix this or what is causing this to happen? -
I thank you for taking the time out to respond. It is connected a table. This same code works well in another table search without a problem. I am not sure if it is the field name or something specific to the field. I also appreciate your comment about the syntax. I do hope to see other response.Leave a comment:
-
Updating a Table from a form
I have form in access what I am trying to do is search by a specific field and fill in most of the filed based on the search. Then update some other fields in that records based on the information that was populated from the exiting table.
I have an unbouded field called txtSearch. I want it to search the table in a field called [Appointment]. Once it locates the appointment field I want it to populate the other field in my form.... -
This corrected my column issue. Thank you so very much. How do I edit in reverse. What I add the form going back to the table?Leave a comment:
-
Thanks I did get the door to display I moved it to column 7. Now I would like to not have it create a new record, but just update the existing record.
Thanks Again. From the code mention what do I have to remove to make it update without creating a new records.
I do truly appreciate your assistance jforbes.Leave a comment:
-
SELECT T_PKMS.ID, T_PKMS.Appointm ent, T_PKMS.[Appt Date], T_PKMS.[Appt Time], T_PKMS.CID, T_PKMS.Load, T_PKMS.Trailer, T_PKMS.[Carrier Name], T_PKMS.[Ship to Name], T_PKMS.[Total Pallets], T_PKMS.[Destination City], T_PKMS.[Total Ctns], T_PKMS.[Floorload by], T_PKMS.Destinat ion, T_PKMS.[P O], T_PKMS.Palletiz e, T_PKMS.[Apply Pros], T_PKMS.[Packing List to Pallet], T_PKMS.[Packing List to Truck Wall], T_PKMS.[Packing List to Last Carton], T_PKMS.[Additional...Leave a comment:
-
Thank you so very much for your response. I did add the new field to the query table but it is still not displaying when I select the appointment number. Everything else does display and I verified there is data in the field.Leave a comment:
-
figuring out the me statement and columns
I have the following vba code It is suppose to go in and search by the appointment field and it fills in others field based on the appointment number selected. This is two fold.
1) I need to add another field but I cannot figure out the columns and how they are associated.
I added txt.door but it is not populating.
2) This has a subform associated with it that I no longer want I just want the information...Last edited by Rabbit; Feb 26 '15, 08:36 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: