Search results

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...

Tried but getting invalid syntax. Expression is: [TotalDue]<0.01

Hi I have just encountered an issue that have not found previously. When designing conditional formatting rules for date fields it would change the expression to date format even though I input as regular integer. I tried a couple of times and this was result. See attached screenshot.

Your a legend! Thanks

I will attach some screenshots to demonstrate. Here is the view open in SSMS correctly: This is view in MS Access - some data displaying repeatedly:

I have a view which is showing all data perfectly in SSMS but not in MS Access. I have tried refreshing link and deleting and re-linking but no success. Anything else I can try?

Found the issue here: https://stackoverflow.com/questions/13993301/editing-record-issues-in-access-sql-write-conflict It required a timestamp column!

Hi before we address issue of form, can we work out why the table itself is not allowing edits in MS Access but works find in SSMS. It happens every time - even if I don't open any forms. It does allow adding records though. I have attached some screenshots Really puzzling as I've never come...

I am having trouble updating any data in one table in MS Access which is linked to SQL server. This happens on form, view or basic table. It works fine to update on SQL Server direct. I have tried closing all open forms/tables and SSMS but still getting this error message. Don't know what else...

@arnelgp is it possible to speed up the numbers - stats I'm talking about are at least 100k...

Thanks @arnelgp This is what they are after! Lets see how quickly they lose interest...

I know how to calculate it! I am just looking if it is possible to show the user the numbers increasing very rapidly until the current figure when they log in to the home screen?

To clarify the counts are actually of how many clients the business has and how many jobs done. This is simple data which will increase with each job entered on the DB. I am after the method that increments the numbers from 1 to the current figure very quickly. Obviously this will be on the...