Search results

I want to have a make table query that will create rows that are empty eg make table puts in IDnumber and has three blank columns 1) name 2) description 3) price for instance. I'll be creating a second query to update these columns, but I'll need empty columns. Thanks, Seth

Ok. I have a form that has a listbox with a number of items in it depending on the search criteria. I would like if a user double clicks the item in the list box for it to open another form that contains the data for that ticket eg. list box says ID Name Date Problem 2 Seth...

wow I'm a retard. thanks

I have a list box that is propagated by a query that query has the criteria that the description field of the table should contain the value of the txtLookup field on the form. but if the description is "I like the car" I can only bring it up if I type verbatim "I like the car" I want it to...

When a user moves through the fields on my form when they reach the end where you submit the form if they press tab the form goes to a fresh form to enter more data. I do not want this if they press tab I want it to cycle back to the first box if at all possible how would I do this? Seth

I really want to have a text box to store my data, and the form I have looks up my data from a table. the table stores a Username. It's fine for me, but my coworkers would rather see a friendly name. I have an employee table to look it up in (e.g. arsmith => Amanda R. Smith) unfortunately, I...

Thanks very much, very helpful. :)

I've a button that I'd like to make put the current date and time in a date/time field I have in my table. It is the table associated with the form. But I just don't know how to do this. Any ideas. I'm thinking I'll have to use the Now() function, but I don't know how to put it in the table...

I have a table that has a department name drop down box, once a user chooses the department the next field is item. I only want items in the previously chosen department to show up in the drop down box. I have a table that has all items, with a department name, and a table with department names...

Where is the save in A97 format menu item?

I have an access 2000 database that I'd like to have people who use access 97 be able to use? how do I convert it most easily? TIA, Seth

I used the wizard to make a query for duplicates but there is quite a great deal of them, and I would like to delete all but one entry so that the following table: itema itemb itemc itemc itemd itemb iteme would be reduced to: itema itemb itemc itemd iteme Is there any way I can modify my...

An append query with criteria like this works: INSERT INTO tblA (item) SELECT tblb.* FROM tblb, tblc WHERE (((tblb.item)=[tblc]![item])); but when I make it a delete query it changes to : DELETE tblb.item FROM tblb, tblc WHERE (((tblb.item)=[tblc]![item])); it says "specify the table...

Thank you so very much, but this works perfectly except for one case. When the form is moved to a new record. If you try to access the other form with the command button it won't let you because there is no ID field. Any suggestions on how to take care of this. If not it's not a big deal. I...

I've got a form with all kinds of data on it about a student, and I have a command button that opens another form that allows you to enter a memo about that student. I've bound the comment box to the memo field in the table, but I need to pass the ID of the student so that the comment can be...

I'm using code to disable a field when a checkbox is checked. Ex. If chkBox=-1 Then Item.Enabled=False Else Item.Enabled=True End If And I've had to put these in the OnCurrent Event of the form as well as the afterupdate on the checkbox. But. I'm using a tabular form, and it's disabling...

I have a couple of large forms that will require the user to have a resolution of 800x600 or better to enter data without having to pull the scroll bars around everywhere. Does anyone have any code to detect the resolution and kick them out if it is too small?

I've got a subform and when the user tabs to it to enter information. They can never tab out of it. I had to set the cycle property to Current Record so they wouldn't be able to add more than one record to the subform. But I can't get them out of the form now. Any ideas?

I tried to do some of these things. But the problem was fixed when I imported all the objects again into a new database. Go figure.

ok new problem. It just stays on that subform. I need it to move onto the command buttons below. but it won't.