Recent content by zandsc1

Well that's not a particularly good sign that different versions of Access are behaving differently. Usually a good indicator that the problem may be harder to sleuth than you would like. Is there any sort of timer event or 'On Got Focus' event for the subform or the main form that houses...

Access is doing some odd things here in terms of what it will and will not allow with left joining subqueries. I loaded up some data into tables to try and match your setup and played around with it until I got the results I wanted. This should give you everything you were asking for...

Thanks. I had to nest the left join into the subquery to get it to run for some reason. This runs without error on my system. See if it gets the results you're looking for: SELECT m.EE_FP_EMP_NUM as EMP_ID, m.EE_F_DIV_NUM as DIVISION, dbo_EE_T.EE_F_SUR AS LAST_NAME, dbo_EE_T.EE_F_FIRST...

Hmmm I know that Access is a bit more limited than SQL databases in terms of join capabilities but it should be able to do a simple left join like this. Your two tables have proprietary data in them so I won't ask you to post them, but can you give the SQL definitions or screen captures of them...

Good suggestions from Andrzejek but I think you're trying to get all the data into columns with joins instead of unions. If so - subqueries are your friend: SELECT dbo_EE_T.TIME_F_EMP_NUM AS EMP_ID, dbo_EE_T.TIME_F_DIV_NUM AS DIVISION, dbo_EE_T.EE_F_SUR AS LAST_NAME, dbo_EE_T.EE_F_FIRST AS...

Is there a really good reason why you don't have a primary key on either the source or the destination? Seems like a longshot but if you can't have a key in the source or the destination for some reason, it might be helpful to add them with SQL (temporarily), load up the destination, and then...

Chr(13) is to use ASCII to reference the carriage return character. I think if you define CR as a string you'll resolve that issue. Opening and searching through excel is not as easy a fix, unfortunately. Excel has it's own class now with it's own set of commands which is a nice improvement...

you should be able to do this very easily in the query builder. Right click on the phone number field and click 'Build...' and in the box that comes up put in '716-' & [phonenumber] where [phonenumber] is replaced by the name of your field containing the customer's phone number...

I've got a similar setup but I'm using ODBC to connect to Postgres. We had to go through and configure the System DSN on each workstation when we started using ODBC so I suspect that will yield results for you if you are installing drivers and confirming the connection. I had played a bit...

Well that's a good sized module to wade through looking for errors... So is this the actual line that's throwing the error: Call dmerge(WordDoc, MergeQuery, SaveFolder) Or is it somewhere within the dmerge function that you posted? If it's the actual 'Call dmerge...' line that's giving an...

Are you requerying the recordset driving the combo box and form after you add the new customer to the table? If your combo box "Limit to List" field is set to false (which it usually is by default) the it will let you put whatever you want in there even if it isn't necessarily in the dataset...

Are you closing the orders by customer form when you launch the order details form? Try tracking the orders by customer subform and seeing what event is causing it to revert back to the top row (i.e. when you launch the order details form, when you close it, when it gets focus, etc).

I found a solution and I wanted to follow up and post it. First, I'm confirming that there is something selected in the listview and then storing that information: Dim mySelection as integer If Me.lsxPriorityList.SelectedItem Is Nothing Then mySelection = 0 Else mySelection =...

First, let's clean up the code a little and make it readable: With Application.FileSearch .NewSearch .LookIn = pubPermitDocFolder 'a constant in GenMods module .SearchSubFolders = False .FileName = finddoc .MatchTextExactly = True .FileType = msoFileTypeWordDocuments If .Execute() > 0...

I've read through the FAQ guides here and I'm trying to figure out a solution to what seems like it should be a simple problem. The users are looking at a priority list of jobs stored in a listview. I'm using a listview instead of a listbox because I want to be able to format each row based on...