Search results

Hi Plog, I think that code is way above my "pay grade"! I started getting a headache just looking at it...any other ideas?

Thanks Plog, It works a treat except..... I am displaying this information on the Status Bar and also in a Msgbox. It is displaying c:\RPR\BACKEND which is where the database would be stored normally but.... I just tested it on another PC running just the Runtime and it is not being...

Hi guys I need to be able to display that actual path that contains the database for my FE/BE application. I can't find where this information is kept. Is there some sort of Access System variable that has this information? Thanks for any help. Regards Greg

Hi Minty I played around with what you suggested and managed to get it to work! Here is my final query: INSERT INTO Customers ( ContactFirstName, ContactLastName, EmailAddress, BillingAddress, PostalCode, City, StateOrProvince, PhoneNumber, MobNumber, Web_Customer_Number ) SELECT...

Hi again Minty, I've been mucking around trying to get this to work better but am struggling. I though that I would explain a bit more what I am trying to achieve. I have a ECommerce website that takes orders etc. I export these orders into a CSV file and then import the CSV file into a Table...

Hi Minty, I'll try your idea and let you know how I go....

Hi JHB Can you please explain what you mean?

Hi guys I'm a newbie so please be patient with me. I have a table called "Customer" that contains customer records (name, address etc). There is a field called "CustomerID" that is configured as "Auto Number" When I add a new record after running a number of Update/Append queries that may...

Hi guyss Ok, here is the update....I got it all working! This is what I did (I hope I use the correct terminology): 1. I created a new function and moved the execution of a number of the macros that were being run in the Autoexec to this new function and created a series of "DoCmd.OpenQuery"...

Thanks, I'll look into this.

Thanks Mark, I'll give it a try and report back. Regards Greg

Hi guys Thanks for the prompt replies and good ideas! I though about having 2 versions of the FE but that can cause other issues relating to keeping the 2 versions the same but it still may be a good interim fix. Markk, as I am a newbie, can you please explain your idea some more? Are you...

Hi guys (newbie) Sorry for the vague title. I am using Access 2007 and have a split design (BE and FE). Everything is running well. I have set up an Autoexec file that contains about 15 different "things" such as Runcode and OpenQuery's. Again this is all working fine. Currently, the...

Thanks mate

Hi guys I spent some time searching but have come up empty handed to I though that I would ask this wonderful forum! Ok, I have an invoicing system that the user can add payments. The payments are in a table called "Payments" and are all linked to the invoice by the invoice's unique number...

Yep, I'll use the debug.print much more now that I am aware of it. Thanks again. Regards Greg

Hi Minty, You're a bloody legend! It took me a little while to understand what you were saying (I'm a newbie) but when I added the Debug.Print code I could see that the SQL code was : Update Workorders SET [SerialNumber] = 44444 261 WHERE [WorkOrderID] = 579; I thought then that the...

Hi guys I have spent the last 6 hours trying to get this VBA Query to work and it's about 98%... Here is the code I am using (It's not pretty but it's the best I can do!): mSerialNumber = DLookup("SerialNumber", "Workorders", "WorkorderID = " & Nz(Me.WorkorderID, 0) & "")...

Hi Gary, The process I currently have flows as follows: 1. Customer creates a shopping cart on the website. 2. An email is send to me containing a list of products that the customer wants. 3. The email is placed in an Outlook folder called "Shopping Cart Orders" via a Rule 4. I read the email...

Hi Doc man What should the references be???? I'm using Outlook 2007 and Access 2007. Regards Greg