Search results

Hey! Thanks for the input. After leading me in that direction, I think I tinkered enough to get it to work. But that 'exist' clause was the missing ingredient, but QBE makes it look a little funny: [code] SELECT IIf(IsNull(DLookUp("Cost","tblQuoteDetailContractor","QuoteDetailID = " &...

Hey guys! Hope you can help pull me out of a bind again. What I'm trying to do is show all fields of all the records in tblQuoteDetail with a QuoteID of 7. Then show the 'cost' field (stored in tblQuoteDetailContractor) for all related records with ContractorID = 1. If the record does not...

I have 3 front ends, so I assume I'd have to do that on all of them. But now I hear that the Access db passwords aren't all that strong... Regardless, I'm sure it's better than nothing. With respect to the windows level login, I don't use windows for the actual authentication. I just use it...

I am using ULS and the login screen. In fact, for all users, the db username and the windows domain login are the same. So could I filter this on a global level? So lets say user jdoe opens up the back end and opens tblContractor. Could it automatically filter the table so that jdoe is the...

Hello AWF friends- I have a table (tblContractor) that contains all of the employees for our location and their information such as address, phone, ssn, and salary info. Every week the employee submit a report that calculates what their pay will be. The pay report pulls data from...

Ohhhh, I get it now, wow....that is really really smart man. I never knew you could do that, and even if I did, i don't even think I would have had the capacity to come up with that as a solution, lol! I did change it to: Private WithEvents xlWs As Excel.WorkbookWith this for the event...

Got it up until this part. How do I assign an event handler to xlWs?

It worked a couple of times, but now it give me the following message and locks up excel: Microsoft Excel is waiting for another application to complete an OLE action. Any Ideas? The problem code is towards the very bottom: Sub FinalizeInvoice() Dim intAccountingContactID As Integer Dim...

Banana, worked like a charm! Microsoft has a good article at http://support.microsoft.com/kb/147816 Final Code: Dim objAccess As Object Set objAccess = GetObject("J:\Interfaces\Source Code\CCE Services Inc - Full Front End.mdb") With objAccess...

Sigh.... due to micromanagement, I have to come back to this later. But that looks like exactly what I need. I'll post back when I can. Thanks again for pointing me in the right direction.

Hey guys, I have a multiselect listbox (lstClosedProduction) in an Access form. The user will make a selection, hit a button, and it will export data to an excel invoice template. Among the data it exports is the unique ID's of the items selected in the multiselection list box. After the...

Hey guys- I'm having some trouble getting a crosstab query to display values from two different table columns in a listbox. I have my first crosstab query that displays ProductionID as a Row Heading, FunctionType as a Column Heading, and TotalPrice as the value. But after it displays the...

Well....turns out there was a problem with the FROM clause and its relationships. So fortunately, I got it to work, but I'm still kinda curious as to why that happened though. FROM tblInvoiceFunction INNER JOIN (qxtInvoiceFunction INNER JOIN tblProductionInput ON...

Hey guys- I have a tabular query that is based off of a crosstab query. My problem is that whenever I try to add a string field to my problem query, it shows an Asian character (not sure which language) and a square. I know it's not corruption because I double checked the table and it's in the...

Very nice!! That is exactly what I needed. I even learned a new trick while deciphering the append query that writes to tblFoundFiles. Thanks again David, you're a lifesaver!

Hey- Thanks for the reply. Unfortunately in this case, the list is going to be dynamic so I don't think that will work. Was thinking maybe I could shell that command, make the file, and have it import automatically, but geez, that's a lot for a simple drop-down...

Hey guys, The subject is pretty self explanatory. I have a directory with all Excel Templates and I want them to be listed in a combo box for the end user to select. I'd imagine that I'd have to write the filenames to a table, and have the combobox query that table, i just don't know how to...

Weird....I must be doing something wrong. But you gave me an idea. Never really thought about letting the code do the multiplication for me...i was always calculating it manually and putting a single integer in there.

Hey guys- How can I retrieve the size in twips of a form window? It seems to always be a guessing game when I use Me.Move in vba to set a window size. I've tried taking the form's width property (inches) and multiplying it by 1440, as well as '?me.move' in the immediate window, but no luck...

I'm having the same speed problem... Once I saw what the expression was actually doing, I had a bit of an aha moment, lol! Thanks again!