Search results

could you post a sample? the db i have is legacy w/tons on unnecessary (i suspect tables, and forms, would take 4ever to clean up), which is why i was seeking sample...i can compare settings. would greatly appreciate

it adds the value, but when it returns to main it's not showing the entire list (hasn't been requeried) and since it hasn't it wants to add it...stuck in a loop

that's what I'm doing, the subform closes fine, but it returns focus to the combo form main (not updated), since the value is still in the combo box, it keeps asking do you want to update.....perhaps I need to clear the combo box?

stuck on how to accomplish this since when i return focus to Form A from B it wants to loop back into the not in items list, figured there maybe another way....which is why i was looking for a sample db

using 2010: think your proposing ListItemEdit form, which calls up the form w/no problem, but when I try to return focus to the orginal form the combobox won't refresh to display the added record and asks the question again. I've played w/closing the main form, etc. then i figured someone must...

I have a form w/combobox, if not in list a subform popups and new user information needs to be entered/save which works fine, but i need the a) combobox doesnt requery - but instead I'm stuck in a loop, of do "do you want to reenter", does anyone have a sample of how they got this to work?

Not sure how to do this...any suggestions (I usually create my forms based on table), I need to have a form that pulls from an external db (I can't write to) so it looks up to (customer info) then the user enters info on a form and all the information on the form gets written to many tables, but...

yes it's paining me, it doesn't work for one form, the form has a double query: form: pick a person, which opens a report that queries on date and [forms]![frmSelectAnalyst]![mylistbox] it works fine w/out the navigation pain

I have a form that uses a listbox with a query to open, which works fine in the switchboard, but doesn't work with the navigation pain....has anyone else had a problem? my select query is: SELECT DISTINCT [tblCompletedby].completedby FROM tblCompletedby; also the form is small in size, (3' x...

being very rusty w/access I'm looking for help. I have a form in which occassionally a user will have to save, the data, refresh the data and duplicate the data w/msg saying you are looking at the duplicate record. I have created 3 command buttons. This seems stupid, i would prefer to have one...

thats the Problem, I don't want to store multiple values in a field & multi-select listbox won't store anything directly.....so what are my alternatives? thinking subform w/lots of checkboxes (which will allow multiple selections) and values (from an ID in a table) are bound to another table

no such selection

Thanks Paul but I started off trying a listboxes w/multi select set at "extended" and it wouldn't store multiple values, only one value. HELP

Been away from access for a while; I have a form with a control (listbox, checkbox, combo box) in which I want my user to select multiple items; Initially i have all possibilities coming from a table w/checkbox, but I've it wasn't normalized that way, so i created a tbl call LOB. Now I'm unsure...

creating a db, not using the autonumber and instead using a txtbox w/ =DMax("[Requestnumber]","tblname")+1, which works great! now I need to duplicate a record, using the wizard this works great too, but now I have two of the same requestnumbers. Searched around forum and didn't locate an...

This doesn't work in 2010, I put this line on the got focus event, anyone know an alternative command?

I've read thru the files on this topic and it doesn't seem like anyone has addressed this issue: I'm using Access 2010 and I want to send the form (not report) via pdf preferability) I have a table that stores the email addresses; button on the form which when the user hits is suppose to make...

I've read thru the files on this topic and it doesn't seem like anyone has addressed this issue: I'm using Access 2010 and I want to send the form (not report) via pdf preferability) I have a table that stores the email addresses; button on the form which when the user hits is suppose to make...

thanks, I checked help for CSTR it returned nothing. Can someone help w/syntax?

can anyone assist? I have a txtbox and the control source is =DMax("[Requestnumber]","tblPMSRequest")+1, which works fine, but now I need to add an alpha character to it, depending on what form is opened. i.e. one form would be coded D, R and G. I've created a textbox on the form made it not...