Search results

I am looking to find a simple way to integrate the Vehicle Enquiry Service API into a database. Can this be done without third-party software? If anyone can suggest any leads on how this or a similar process can be done. Thanks for your help

This is EXACTLY what I was asking for! Thank you

I do not wish to create payments until they are approved for processing. So I would like a query to show the upcoming possible payments. Then it should be possible to select which payments to actually create. Once created the payment can go through the processing stages. The only field I have...

I am planning a DB to manage payouts to various companies on specific day of the month. I have figured out the following structure - a staff table; a junction table recording staff/company/payment info (including day of month); a table recording transactions info. The process is that each staff...

You have started great. To obtain your IP address go to command prompt and type in ipconfig /all - see screenshot below:

Hi, In short the word 'audit' must be added to the tag property of every control you wish to audit. I have some useful code which iterates through every form to do so. Option Compare Database Option Explicit Dim bIsLoaded As Boolean 'Iterate through forms Public Sub tagsAllForms() On...

Sorry I try running the code now but it will not compile 'user-defined error' if the MS Word reference not present.

I am trying to use the file you provided but every time I click MergeAll the database shuts down and restarts and I have no idea what is causing it to do this. The code compiles and I have even removed the progress bar code to be on the safe side but no luck.

Thank you for this I am also trying to use Albert's code but would like to make some amendments. 1. The user can select a previously created file and use as a template. 2. The files do not all need to be saved in the same location (using a table to store static file addresses). 3. Option to...

Thank you for the offer. I have enclosed a sample DB with 10 records filled in. The query 'qryMailMerge' should have all the info for the merge. Also the italised words in the template would be where the merged fields go.

Hi I'm planning a DB to be linked to Azure so it can be accessed globally. The question I would like clarified is whether it is always possible to access the DB even without internet connection. Or if it requires access at all times to the server?

This sounds like an interesting approach. Would you have a sample app where it is integrated in?

Thanks @moke123 but that is a little too advanced for my needs. My key problem at the moment is how to successfully link the data to the word document from DB whilst open. Every option I try throws all kinds of errors. I tried OLEDB and DDE but it will not work. I have read through all...

Hi there, Further to my post above, I have been able to start coding based on some snippets I have found but my code keeps throwing errors particularly 4198. I have enclosed a sample. Bear in mind that my DB is split with BE being another Access DB (hence the connection string). I've never...

Hi I'm looking to integrate a mail merge facility into an MS Access DB. I know there are solutions to this out there but couldn't quite find what I'm after. I would like as little user input as possible. So the user can select a letter template they wish to merge with a particular data source...

So it seems to work when I convert all values between 0.01 and -0.01 to 0 so all the tiny values are filtered out.

This is the SQL SELECT tblTenancy.TYNAME, tblTenancy.TYADD1, tblTenancy.TYADD2, tblTenancy.TYADD3, tblTenancy.TYADD4, tblComments.*, tblInvoice.ItemDate, tblInvoice.ItemDesc, [ItemAmount]+[ItemAmVAT] AS cfInvTotal, [OutStand]+[OutStVAT] AS cfOutStand, [received]+[recvat] AS cfReceived...

Wow that sorted it! Thanks

Difficult as it is sql server

I am having trouble with a split form. When filtering one field to 0 it will not display all the records. It will work when I use a number filter 'equals 0' though. I have checked if there are any underlying filters on the form and also if it works to do in the underlying query but not managed...