Search results

Hi Guys My Access 2007 application uses DoCmd.TransferText option to import numerous CSV files into various tables and has been working well for years. The want to change one of these Imports as there is an additional field in the CSV file that needs to be imported into the table. It is called...

Hi everyone, I have looked and looked and can't find the answer to this issue so I am posting here hoping for some help. I have developed a comprehensive Stock and Inventory system using Access 2007. Here is the issue I have. I have a main form called "BulkPartsMainForm" It has a number of...

Hi guys I have the following query that displays the selected data as a Pivotchart. DoCmd.OpenQuery "qPaymentsQueryJustMonth", acViewPivotChart I action the about via an VBA Event. This all works fine The graph displays the "Sum of Payments Amount" on a monthly graph just for all the...

Hi Everyone, I have been trying to resolve this issue for hours and have finally decided to ask for some help as I am sure it is something very simple I'm missing. I have provided a "cut down" sample database (XXLateral.zip) containing just the form and 2 tables and a query. It is in Access...

Hi Guys I have spent many hours today trying to sort this issue out but I'm throwing my hands up for some help. I have a table called "Parts" and a query called "qExportPartsToCSV". I have attached a sample database with these in it. The Parts table contains records relating to various cars...

Hi guys I have a continuous form displaying a number of text boxes. I have a text box called “txtNewPrice”. I have some VBA code that I use to keep track of when the user manually changes the data in txtNewPrice via a module that is triggered by the “Before Update” event. this all works...

Hi guys I have a table that contains a list of Parts in a stock and inventory type of database. It has field called "[Markup]" that contains the percentage markup and is calculated and updated each time the database is start via a query. The [Markup] field is defined as a Percentage field...

Hi guys I've been trying to figure out the following for some time. I have the following code on the On Mouse Down event of a TextBox control on a form in Continuous form mode that is in a Tabbed form that I have been using to try to determine the cause of my problem: Private Sub...

Getting most recent record using Grouping query Hi guys, I have been struggling trying to resolve this issue for days and just can't seem to crack it so I'm throwing it out there for some help.I have attached a stripped down version of the database as well.I have a table called "PARTS". It...

Hi guys I have tried to figure this out myself without success. I have a form that is popped up when the user clicks a button on the main form. This popup provides information that the User must read. There is a "CLICK TO CONTINUE" button on the popup to enable them to continue to the...

Hi Guys I have tried to figure this out but can't so I'm hoping I'm missing something easy that somebody will help me solve. I have a query that basically chooses records from a table that contains a list of Invoices with a field, [InvoiceDate] based upon the following criteria: Is Not...

Hi Guys, I've spent hours trying to figure this out but just can't crack it. Here is a simplified explanation: I have a form (Form1) that has a tab control that has a number of Sub forms called subform1, subform2, subform3 etc. On subform1 there are text boxes called "TextBox1", TextBox2"...

Hi guys, Whilst I am still learning about Access and VBA I'm not a total "newbie" and have developed a large application. I now want to tidy up the code so as I have a lot of code duplicated from form to form. For example, I have a form (called Form1) that has a number of buttons that have...

Hi guys, I have an error that I am having trouble tracking down. I have a Microsoft 2007 environment (Word, Outlook and of course Access) running happily on a Windows 10 (Home edition) of a desktop PC. I want to move the entire environment onto a laptop running Windows 10 (home edition). I...

Hi guys, I have many existing saved Select Queries that are attached to either a form or report. If they are attached to a Form, I have a text box with the following in the Control Source to total a column: =Sum("[Parts Total]-nz([Total Payments])") All of this works well and these queries...

Hi guys I hope I can explain this correctly as I am a bit of a newby. I have a form that has a number of Command Buttons on it (I call it a Dashboard). I have attached a screen shot. Each button executes a report. All of this works fine. I have a text box in the Form header of each report...

Hi guys, I'm a newbie to Access and VBA so please be patient as I try to explain what I am doing and trying to do. I have a simple Access application that I am using DAO to connect directly the Outlook Inbox in order to import email information into a table so that I can query it. I am not...

Solved: Read/Open Outlook Email incorrectly in new instance Hi guys I am trying to have the ability to open/read an email from Access 2007 and have the following VBA code working. Private Sub Command395_Click() ' This code finds the 3rd email in the Inbox and displays it in a new Outlook...

Hi guys I hope I can explain this. I have a split application (BE/FE). I have a table called "Web_Orders" that contains a number of records. If I look at them, the ID (Unique) field # is 6888000. This is due to the fact that each time the app is started, I run a number of imports...

Hi guys, I have a query that I wish to call via VBA and display the results as a PivotChart. I also want to pass it a parameter to enable me to restrict the amount of data being displayed. I use a command button on a form to trigger the VBA Event> Here is my code: Dim sWHERE As String...