Search results

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

Hi I'm not sure what the official name of this is so I'm not able to search for it but I'm sure there's a way to do it. I'm looking to increase the stats on a form on open to the current figure very quickly from 1. I often see this effect on websites e.g. on Forbes it gives figure of number of...

So only option is to specifically close it in the function it is opened in?

Thanks but would like to keep some forms open. I am more concerned about open references to objects which are no longer being used.

Hi I'm wondering if anyone has code that can close open objects in particular emails. I think these are still knocking about in my database and causing issues. I have code to close all recordsets when DB closes so looking for something to that effect. Like this: Public Function...

Whenever I do that it doesn't save when re-open form.

Hi Is there any reason that tab order is greyed out for a form in Datasheet format. My real problem is that I can't get the columns to display in a different order so I thought tab order would help me. Any thoughts please

Sorted thanks (y)

Hi I've come across an annoying error which has not happened previously. My MS Access DB recently migrated to SQL Server successfully. I have since added various fields of varying field types using SSMS. I noticed the checkboxes would come up as textboxes on forms so I would insert a checkbox...