Search results

I'm trying to accomplish something similar, except on a daily basis. I need to get my query into a pipe-delimited text file, and I already have a working TransferText function set up: DoCmd.TransferText acExportDelim, "qrydaily_export", "qrydaily", "C:\file path\CLC_MOS_" & Format(Now()...

Thanks for all the good ideas - I ended up going with the Boolean flag, which is what I was trying to accomplish in my head but just couldn't quite figure out how to make it happen. Works great now!

That sounded like a great solution and I was in the process of implementing it. And then I realized that the user may not actually change these two fields. They may need to stay as is. Back to the drawing board? Thank you though!

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 stared at that thread for a while too. I think the answer may be to pick this up again tomorrow after some sleep. Thanks, though!

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

worked beautifully. Thank you ever so much for your assistance!!!!!

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 am an idiot - had no reason to base it on a query instead of the table. problems are all solved.

scratch that - I have a lot more issues than I though. I'll be back when I figure out what I did!

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

the column count did it! Yay! I guess I missed that very important piece of the puzzle. Thank you ever so much - this has been bugging me for a while. I may change them to the regular number format anyway, as I've run into some other troubles with the currency format too. Thanks to everyone!

It's 1 for both of them.

Good call - but Nz still gives me 0. I ran the query to double check, and the name I am testing with definitely has a corresponding rate. The only thing I can think of that is different is that the Rate fields are currency in the underlying table. Could that be causing the problem? Thanks!

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

Union query = beautiful, wonderful, my day is now better! Thank you!!!

I changed my column count and I can see the second column now. However, that's not what I want to see. Instead of seeing Translator / Translator 2 when I click the drop down and having to select both, since they are together as one option, I want to see Translator Translator 2 and I only want...