Search results for query: *

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

Have you considered making a sequence and using it as the key for both tables? CREATE SEQUENCE sequence_name(... sequence parameters ...) CREATE TABLE table1name(table1_id PRIMARY KEY DEFAULT nextval("sequence_name"), ...) CREATE TABLE table2name(table2_id PRIMARY KEY DEFAULT...

philhege - thanks for the suggestion. I think you may be right. Off to do some research on triggers. Thargy - this would hold true given your assumption, but I'm afraid the assumption doesn't work in our case. There are instances where a new revision of a part is created, but not released...

Ah very interesting denimined. That does solve some issues. I may be able to simplify further and just reference the CRID in the CL table, since that CRID has a FK pointing to the CID, and the CRID for a given lot should never change (once the lot number is created for a specific rev of a...

Looking for something that's similar to a unique constraint. The scenario is that I have a table with part numbers and revisions in it. In order to maintain change history, the old revision of the part number stays in the table when the new revision is released. Now say I wanted to create a...

I have a schema that I'm trying to normalize: Component(component_id, component_number, component_revision,...) Component_lot(component_lot_id, component_lot_number, component_number, component_revision,...) Component_supplier(component_supplier_id, component_supplier_name, component_number)...