Search results

I have a combo box that uses a query as the row source. That query picks a value from a form ([Forms]![Q & D]![Translator]. It works great. Now, I want to add a second field ([Forms]![Q & D]![Translator 2]), so that it appears as another item on the list in the combo box. If I add it as a...

I found some posts that might help with my problem, but unfortunately the code is way over my head. I have a subform (Feedback) that opens from it's parent. It draws two fields (job number and name) from the parent form, and that is working just fine. I set the On Open to create a new record...

Works beautifully! Thanks for helping me straighten things out!

Hi- So I currently have a simple form, in which you select a persons name from a combobox, click OK, and it brings up all their records with a query. Shows up in datasheet view and it works just fine. However, it would be much more user friendly/easy to see if I could have it present that...

Beautiful! That's exactly what I was looking for. Thanks much!

Hi everyone- I am working on a new form (frmFeedback), and I have a combo box that draws from a query. The query has one field, which is an expression =Forms![Q and D]![LS Number]. It seems to be working well, but for some reason when you click the drop down, about 17 of the same LS number...

Thanks, that did the trick!

I am trying to use a Switch expression as a column heading in a crosstab query to generate statistics for how much work is done per client (Requester). Each requester is referred to by acronym, so it may look like "DOD/OUSD/FTT/ATA/B", but I want that column to include everything that starts...

Hi- In a subform, which is based on a query with two tables, I have a combo box (Field36) that is used to select a name. In the OnExit event, the following code is used to refresh the remaining fields on the subform: Private Sub Field36_Exit(Cancel As Integer) On Error GoTo Field36_Exit_Err...

I checked regional settings, but didn't notice anything out of the ordinary. The only drama is that her computer is set up for Chinese. The default is English(US), but then she has simplified Chinese, Taiwan Chinese, etc. etc. etc. She ahs two programs that enable her to type in Chinese, and...

Another important thing I forgot to mention- the error it gives me is: Error 2465: Application-defined or object-defined error. Please?

That was a good idea. I tried it, and they still don't show up. What I did was remove the current printers, then add the correct printers that everyone else uses. Should I have restarted in between? It's utterly mystifying! Thanks for your help!

Hi- I've played around with VBA quite a bit, and can make it do things I want it to (usually). No formal training whatsoever, but I got picked to be in charge of this database, so I'm doing my best to learn. Long story short- I'm using the following code to generate two email messages. I...

I posted about this sometime last year, and never got an answer. I have a multi-user database, with front-ends on each user's computer and a back-end on the network. Everything is working fine at the moment, except for one computer. There are a series of reports, each containing lists of...

My table links were messed up, which was throwing everything off. I fixed that and now it shows up! Happy day!!!!

Ok checked that out- I picked the form from the drop-down list, so I can't imagine that it can't find it. I did notice that the Link Child Fields and Link Master Fields names were wrong- I had missed those when I moved it over. Unfortunately it still does not appear after I corrected that...

I am in the process of upgrading a database, mostly by borrowing things I like from a similar database. I've borrowed a subform, along with it's underlying query and have modified my tables accordingly. All fields should match up. Said subform is embedded on a page of a tab control. I've...

We work in a translation office, and were recently called on to translate several tables and forms in Access 2003. The field names were translated in Word, and then copied and pasted into Access. The Armenian font was installed, and the names show up correctly in the table. However, those...

More drama with the subforms Hi again- So, I got my tab controls all straightened out. (thanks again!) The first one shows up perfectly. I embedded my second subform on the second page, and have been diligently modifying it for about a day. (background: I borrowed this subform from another...

You guys rock! Problem solved