Search results

Hi I have a macro that writes the results of a query to an excel file. When this macro runs I get an error MS office cannot start OLE server just before it tries to write it to excel. Does anyone know what causes this error and what is the solution? Any help is appreciated. Thanks.

Hi, I have a query which imports data from a linked table. One of the columns I import is alpha numeric, when access imports it, it sets the format depending on what the first row is to either "number" of "text". However because of this it does not see any records which are in the other format...

Thanks uncle gizmo. I'll try that and let you know.

Hi, I have a query (say query1) which contains item numbers and their stock levels at various locations. The item numbers appear multiple times since they are stocked at multiple locations. I want to design another query (query 2) based on this query by joining the item number columns however, I...

Yes, got it. It's working. Thanks!!

great!! so would it just be round([column_name],2)?? in the field for criteria?? Thanks!!

I was wondering if it's posible to specify the number of decimal places in a select query output?? I am currently getting 5 decimal places and I need only 2.

Hi, I have an access table which is empty, I need to link it to a DBF file which contains the data that should be in the table. The reason why I need to link is because the DBF file is updated every week and so I would want my table to be updated too. And the reason why I need the table is...

No problem :) It could show any of the two PO's, it doesn't matter - whichever is easier to show from a programming perspective ;)

:) Thanks!! Keep me posted in case you think of something.

Hi Brian, Thanks for your reply. I may be wrong, but my only concern is that, if I do a group by on everything including the PO numbers it would only total if the two PO numbers are same, however, I want it to total only if the two PO numbers are different but the item, branch and due dates are...

Hi, I have a query which contains item numbers, branch, purchase order number, qty and due dates. This query looks for the closest due dates to the current date and displays those records. In some cases there are two purchase orders having the same due date and both qualify as the earliest due...

DUEDT:IIF(IsNull([SNDATE]),[EINDT],[SNDATE]) I am using this expression to make a column which contains the SNDATE if the field is populated or the EINDT if the SNDATE field is not populated. It was working fine, however, all of sudden it is giving me a "visual basic module syntax error"...

Hi, I have a bunch of queries that I need to run in order to get the final result. I was wondering if there was a way by which I could create say a single .exe file which when run would run all the queries in a sequential manner? Thanks.

Thanks Rabbie. Going a step forward - If I am looking for the min date per item for a group of PO's, how can I set it to return only a single value in case there are more than one PO's with the same min date?? Thanks.

IT WORKED!! Thank you SO MUCH!! I appreciate your help!!

Hi, I am looking to join 2 queries, with similar columns, the second query has a few columns less compared to the first query. I am using the union query to obtain a result which contains the records from both queries. The code I am using is: SELECT B44MinPO.material, B44MinPO.plant...

Hi Rabbie, Yes, I did. However that gives me error 3001. So I just created a new mdb file. I am not sure if there is anyway I could reduce the size of the old mdb file or would I just need to delete it??

Just to give you an idea, what I have is a query consisting of 6-7 columns of which PO date and material are two columns. I want to retain only the records with either blank due date or the min due date per item. I plan to do this by using group by for the material column and min for the due...

The issue was -- the mdb file exceeded 2 gb!! and now everytime i create a new mdb and run the queries i created the mdb file hits 2 gb!! :O