Search results

I have a report list has outlined text boxes which are all lined up nicely to also show the total and the VAT etc. The list of items on the report have which auto resize when the item description increases and decrease. Dim numDescHeight As Integer numDescHeight = txtDescription.Height...

I want to open a form to a specific record with two where conditions. I have it working with one but just cannot get the syntax correct to join the two together. I have tried using AND but just cant get the quotes in the correct place. These are the two conditions I would like to join together...

Is there a way of replying to a specific email from an Access application? I have a module that will generate an email with a specific subject line and body with variable references as well as attach a pdf however is there a way of replying to an original email that is already in your outlook...

I am currently building a small application to create quotes for customers. I have place all of the data in a separate linked backend Access database containing several tables with the sales data, customer data and supplier data as well as some very small lookup tables. There will be a maximum...

Ive spent far too long trying to work out why this code doesnt work. This should be so easy and its not even Friday. I want to programmatically create the RGB for the header backcolour on a form by looking up the values in a table based upon the status The table is called 'tbl_Status and...

I have been using code that I obtained from the Microsoft Learn site and have been using this in one of my customer applications for quite some time now (maybe two years). The application opens a form that runs code that uses the function below to relink several SQL tables (it deletes and...

I have modified some code that I have found on the web so that I can export a query from Access into an Excel template. In the template I have a formula that calculates two columns but I want to generate this in the code so that the formula is only there when there is a row in the Excel file. I...

I have a form that automatically refreshes after a set time which is set by the user. They can set the refresh rate to anything from 5 seconds to 120 seconds using a dropdown box on the same form. This all works and I also have a text box displaying the date and time of the time the form was...

I am using MS Acccess 2019 and I need to amend the SQL string of a linked table so that it points to another database. Can this be done without having to physically go and link the table again? I thought previous version of Access had an 'Edit' button on the Linked table manager but this is not...

I need to create a bespoke reporting tool that will allow the user to select multiple options from a combo box but want to avoid using the built in multi valued field. I have a record set with an ID, a status and various other pieces of information (such as date created, created by, quote value...

I have a piece of VBA code that opens a form and filters the results with a two column criteria, which works perfectly. DoCmd.OpenForm "sfrm_Report_Detail", acFormDS, , "[Status]= '" & Me![Status] & "' AND [Table]= '" & Me![Table] & "'", , acDialog However I need to add a third filter...

I have built an application using Access inbuilt tabbed navigation forms. I am not able to change the system not to use the built in nav forms now because the system is way too far along for that and very complex. I have several tabs within my navigation form. The Home tab contains a subform...

I have a function that is called when my application is launched, and it relinks my SQL tables. Which was working perfectly well until I move some local Access tables into SQL and then had to renamed them in order for the application to continue working. For example I had a local backend...

I have an Access application that is linked to some tables in an existing SQL database plus another 148 local tables in a separate backend Access databasae. I would like to move the backend Access tables to the SQL database and then link them back to my application in the hope that the SQL...

can anyone explain why a calculation in an Access query gives a different result to the same calculation in Excel. For example 1/70 = 0.0143 in Excel (this is the correct answer) but when I do the same in an Access query I get the result of 1.42857142857143E-02 How do I write the calculation...

I have searched the web for a solution for this but I havent been able to resolve my issue despite others having similar issues. I have a form with a text box using the built in date picker. I want the user to be able to manually type in a date or choose one from the date picker. Once they...

The code below exports data to an Excel workbook with 3 tabs. The code works without any issues however when you open up the Excel file for the very first time it has all 3 tabs are selected and you cannot use any of the buttons on the Data tab ribbon until you select one on the tabs. Not a real...

I have the following code which imports a CSV file from a hard coded directory and filename (which is created dynamically) but I now need to change it so that the user receives a prompt to select the file they would like to import from a hard coded directory. This is my current code which works...

I am using on of Allen Browne's functions (see below) to concatenate related records into a string. However I am occasionally and randomly getting an error 'Cannot open anymore databases' and the title in the error message suggests that it is this function. One suggestion is that the function...

I have two datasheets on a tabbed navigation form which I would like to synchronise horizontal scrolling. Not sure where to start or how to go about this or if its even possible. Each form is bound to separate tables with 18 columns (RA, RB up to RR, one for each type of Box) that contain...