Search results

Hi mate I tried it but it did not work. It prompts me to manually enter the WorkorderID as per the attached screen shot. Here is the entire SQL code: SELECT Customers.*, Workorders.*, Employees.LastName & ", " & Employees.FirstName AS [Employee Name], [Customers].[ContactFirstName] & " " &...

Hi guys I've been trying to figure this out but am struggling. I have a form that displays a list of outstanding Workorders (these are basically invoices) in Continuous Forms mode. There is lots of information displayed including name, address and of course the unique Workorder number...

Thanks mate

Thanks sneuberg I'll try out you idea and let you know how it goes.... Cheers Greg

Hi again CJ, I did some more Googling and found the following that seems to be the cause of the issue I'm seeing. I have an idle timer setup to automatically close the app. If I close the offending form, the VBA editor issue doesn't happen anymore...

Hi CJ, I'm am using Access 2007 and it is the Access 2007 VBA Editor. I am also using a wireless keyboard and whilst I do also occasionally experience the same issue you mentioned., the issue with the VBA editor is different. What is seems to be doing is removing "spaces" between words as a...

Hi guys This has been driving me nuts for sometime.... When I type in the VB editor, it seems to what to always auto correct and always gets it wrong so that when I want to type something like a comment: 'This is a test comment to show you what I mean It will type the following: Thisisa...

Hi guys I am using Access 2007 and have an application that already has a number of Pivot Charts that are all working correctly. I tried to created another Pivot chart on top of a simple query and have the following problem: I have a table that has individual records in it for each item in an...

I'm using 2007 as my development environment and 2010 a the run-time when I deploy it. I'm also testing it by simply renaming the accdb to accdr and it doesn't work then as well.

Thanks for the link. I managed to create a Pivot chart and it works fine whilst I am in developer mode but when I switch it to runtime mode, when the button is clicked to activate the form, I do not see the pivot chart...it displays in single record format.... This is the code I am using...

Hi guys! I just had a cup of tea and then came back and had a play around with Pivot charts! I got it working! Regards Greg

Hi guys (I'm a newbie so please be kind :)) Ok, here is the issue I have, I have a report that I have created that counts the number of "Workorders" and sub totals them for each month of the year. I use the "Group by" option of the report function. This works well. I want to create a simple...

Minty, you're a legend! Thanks mate, I was trying to add another condition to the WHERE clause but just couldn't figure out how to do it...I previously added the Left Jon to the Web_Customer_Number but I still had the other Left join in place... Thanks again. I'll do some more testing to make...

Thanks Minty I'll try your suggestion and let you know how I go. I've just discovered a big issue that I need to resolve asap and have spent hours but I just can't figure it out and I am sure that I am missing something easy. The data is imported into the Customer table and from then on, the...

Hi Gemma I,m not using the Auto Number field for anything important and therefore it's not a high priority for me to look into changing..... Thanks for your input though. Regards Greg.

Hi Minty I have been playing around a used the TOP parameter and it sort of works except it only provides me with a single record to insert for the first "group" of email addresses. If I have 10 new emails addresses to add across 100 records, then I need to run the query 10 times and it would...

Hi Minty Are you saying to change the import query that is being used to initially imports the data into the Web_Orders table? If so, then I don't think that will work as I need to have all five records as each record contains information about the product that has been ordered in addition to...

Thanks guys

Hi guys I managed to do what I needed using Dlookup to get the value I needed from the msysobjects table. Thanks again for your help. Regards Greg

Hi CJ I had no idea that these hidden tables existed! I'll have a play around and report back. Regards Greg