Search results

I have after update events on two form controls that check for duplicates and pop up a message to warn the user if a duplicate is found and runs a query to show them the dup. record. This works fine. I've been asked to add a button to duplicate a record. I used the button wizard since that...

I've been staring at this for way too long now. Could someone review my DLookUp to figure out what's wrong with my syntax? =DLookUp("[transrate]","tblLinguist_Lang","[LangID]= " & [Forms]![frmmainentrytest]![txtLangID] & AND "[LinguistID]= " & [Forms]![frmmainentrytest]![txttransID] &) All...

Hi- I have a very simple mail merge set up with bookmarks from Access 2007. I'm happy with it, however I need to specify that it opens Word 2007, as unfortunately both 2003 and 2007 are installed on these machines (out of my control). I was hoping that having the Word file be .docx would do...

Hi- I have consultant names saved as Last, First in my database. I have a VBA function that I use to switch the name order, so when I automatically generate an email using VBA, it says "Dear First Name." It works great. Now, I need to get some of the information into a PDF, rather than an...

I need help with a query situation. I set up a lovely report based on a joined query. It displays just the way I want: Job Number Title File Name1 File Name2 File Name etc. My client has to be able to export the data to Excel to share with non-Access users. I was exporting said report...

I'm trying to put together some statistical reports using a crosstab query, and failing miserably. Here is what I would like to do: I have 5 fields (A, B, C, D, E) for ranking items. The available values are 0,1,2,3. What I want to do is show how many of each number was entered in a given...

I'm a little rusty, so thanks for your patience. I'm adding a new form (Form2) to a database I made a couple years ago. The form is based on a query. It has one subform. All of this is working great. I open Form2 from a command button on another form (Form1) - I have some linked fields that...

I have two Combo boxes on a form ([Translator] and [Editor]). They are both based on a query (qrylinguists) that has 4 columns: Linguists.Name Linguists.Email Linguists.Translation Rate Linguists.Editing Rate I have the Column Width set to zero, and it works great. I generate an email off of...

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...

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...

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...

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...

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...

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...

I'm upgrading a form that was designed a while ago (not by me). It has various text boxes/combo boxes/etc. and one tab control that has 3 pages (TabCtl87). It works fine, I want to leave it there. My goal is to create another tab control on this form with two pages. One will include combo...

I have done some serious searching and have discovered that many others have posted this question, but I couldn't find any satisfactory answers. I have a FE/BE Access 2000 database in a multi-user environment. I have my default record locking set to "No Locks" (optimistic), but for unknown...