Search results

Lisa, The combo boxes always allow you to bound one value from it, but you can pick up using code the others. Columns stored have a reference starting at 0 not 1, which i think you have noticed. To get what you want you are best to create a simple table called Tbl_Vendors -Vendor_ID (Primary...

and if all the question are in the same table then just put one save button outside the tabs so it saves all the information! One button one procedure. ..and as ken says create it with the wizzard.

If i'm thinking along the same line, if your sub form is a datasheet view and you wish to select a list of Employee ID's then you need to set a lookup in that field in the table properties. There is another tab where you can get it to look up other values from another table it will act as a...

Galantis there is a small error in the SQL statement of your query when you tested it. SELECT DOCUMENT.TITLE FROM DOCUMENT WHERE (((DOCUMENT.TITLE) ALike "*work order*")); to do a wildcard search you just do ( Like "M*" ) you have an A infront of Like.

You could have a form with different buttons and then update the forms filter when each one is clicked. If you goto the help file in Access and type in form Filter this will tell you what to do and should work fine.

Yes you can but if you are using sub_forms just linking the Master and child fields together will automatically put the ID in for you when ever a new record is created. These are in the properties on the sub forms. Use the wizzard when adding the sub form and if the Employee_ID fields are the...

to complete it type the field name in the order by of the sub form to get them sorted how you want. Plus - when you add your sub forms don't forget to link the primary key to it's children in the other tables so that when you add visits and treatments the records all relate to the customer if...

Brian, What i would do is lock the date of modification field so knowone can change it at any point! You could then do two things either use the form event "On Dirty" which means any editing of the data will be picked up and code can be run or place the following into the save/update button if...

Chris, You could email me the db file my email address is visible, but why do you want to post some of the field data to another table when confirming the appointment. This is how i would structure it, i do appreciate your knew to this so am trying as best i can to help. 1: TblCustomers 2...

Here some help. Issue 1: - Yes you can strObjectFormat = cboExportObject.Column(3, cboExportObject.Value) Obviously replace my object names with yours. Issue 2: - Correct me if i'm wrong but it will overwrite because you will be on the same active record for that vendor in the table. You...

I could do that and set it to Data Entry only It's just they way i have done it. I found the problem the first time it happened, so i would like to know what is doing it anyway. Thanks

You could use a select statement after you have selected which type of payment it is. If you use a combo box to hold the different payment types after it has been changed you could add something like. Dim sPaymentOption sPaymentOption = Combo.Column(1, combo.Value) Select case sPaymentOption...

Please can you help me find the issue to my problem that is probably hitting me in the face. I have an unbound form to which i use an append query to post the data from the fields on the form to a table. The table is set up very simple and has a primary key which i will never duplicate as you...

Chris is all the information in one table? and how many forms are you using exactly? If you create a simple appointment booking system, i would have one form to enter the appointments in and another form to view and be able to confirm any appointments. If you are editing a record as long as...

Trying not to get too complicated but if you have an employee master form you can put the orders form in as a subform and link the two Employee ID fields together you can do this useing the sub form wizzard easily enough. Once an employee loads up his details on the master form and adds any...

DT Just a thought there isn't a .ldb file that isn't being deleted when you close the database down is there?. I have had a database shared across a network and occasionally the lbd files on the serving machine would get locked and i would have to delete manually. Either that or the form...

Guys, Please can you help me find the issue to my problem that is probably hitting me in the face. I have an unbound form to which i use an append query to post the data from the fields on the form to a table. The table is set up very simple and has a primary key which i will never duplicate...