Search results

Does the recordsource contain two tables? Are you saving the record prior to opening the report? What exactly do you mean by “refreshing”; code?

Certifications and expiration dates should be stored in a separate table with the AFD_ID (assume this is your primary key in your personnel table). Each certification for each person creates a new record. Your current structure doesn’t allow for easy addition of new certifications. You would be...

While you are fixing your form, you might want to research “data normalization”. You are store data in your field names. A friend suggests you are “committing spreadsheet”.

I believe you need to study "normalization". There are many posts in this site as well as resources on the web. Your "problem" will never end if you continue with your current structure with "Ever employee has a field". Data is supposed to be stored in fields rather than used as field names...

Now, I had to research “codpiece”. I’m fairly certain I can use this information in future social interactions 😁

Aren’t all the BEs consistent in table structures with the only difference the data? If so, there no need to relinquish as long as the paths are the same.

I wasn’t sure what you meant by “up to the path”. If you mean matches the path exactly, why would you need to do anything with delinking? If the connection paths are the same, just deploy the new FE.

I would not delete any linked tables. Instead simply update the connection property using code found readily on the web. Another option I have used is to create a mapped drive and folder structure to mimic a customer environment. If their back-end is on a an “L” drive, I will map a folder as a...

Consider providing more information. Start with what’s not appropriate regarding the date picker? Do you want something larger or what? Did you check out Colin’s link?

If they can’t get “their hands in my tables”, they probably won’t be able to use your application. Also, I’m confused why you would want to use code to open your password protected application. Typically, you add a password and the user gets prompted when attempting to open your file...

You didn’t add much detail however you can add a text box with a Control Source like: =DMax(“DateFieldName”, “TableName”)

I’m not sure about all the code but the filter displayed in the text box has the chkDate between the higher value and lower value. This should be reversed.

Yes, thanks for another catch of a pre-coffee post.

Actually, I would simply display the time in hours with decimals like 25.15 rather than 25:15.

Doug Steele has a more complete date time formatting function here.

Great page Colin. I started using Access V1.1 and kept using new features until v97. Almost every application I have created since ignore newer features.

Can you please get your data and results to match exactly?

Every copy of your subform will have a different subform control name which is used in the expression provided by @mike60smart

I'm confused since your data file does not contain the value 99030110. This crosstab is as close as I can get/guess based on your requirements and Special Duty text file. TRANSFORM Min([Special Duty].Rate) AS MinOfRate SELECT [Special Duty].[Entry Summary Number], [Special Duty].[Entry Summary...

I have purchased one or more of these from legitimate sources and have had no issues.