Search results

I have a customer table. The customer ID consists of both letters and numerals. I want a validation rule making the first character a letter

Property sheet is not displaying when in form or report design

What is the easiest method of installing a backup option into a deployment package. Or the easiest way to backup once package has been installed? I am using Access 2019

I have lost the Save and Publish/Package Solution option from the File Menu. I have tried to reinstall it by going thru Programs and Features and activating the Solution Package Add-in and it still does not appear. It does not appear in the as an add-in option on the database either, although it...

I have a database that I prepared for a friend. He has bought a new laptop and wants to run the database from a new location. Neither laptop has Office installed and the program works fine on his original laptop with runtime 2007 but does not work on the new laptop.

I have a form based on a query which has 5 fields from a table and 4 calculated fields. I have included the calculated fields in the query rather than on the form itself as I want to add additional calculated fields on the form to total the calculated fields from the query.(In the Form Footer)...

I have a table which has lines 1-18. On completion of the last line the cursor goes to line 19 to enable entry of new record. I have a form based on this table which has a number of calculated fields. The formulas are carrying down to row 19 even though I have not entered a new record. This is...

I have a calculated field in a table which returns the difference of 2 values. If the difference is between 1 and 18 I want to return a new value of 1, between 19 and 36 =2 and 37 and above =3. How do I do this?

I have a report which displays live scoring. I have two linked databases. One for input and the other displaying the report on a TV as a 2nd monitor. Data is updated on the report timer. It works fine until the screen is full. I have another function which scrolls down but stops when it reaches...

I have 3 fields (R1,R2,R3) containing scores and am trying to extract the best 2 scores. One of the major issues is that one or more of the 3 fields could contain a zero value. R1 R2 R3 Result I get 80 75 0 80 75 155...

hi, I am a retired self taught access player. To call myself a programmer would be a bit of a liberty. Most of my problems have been solved by trial and error and I am sure that some of my solutions could have been solved in a simpler way. The database I have been working on is for my golf club...