Search results

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.

There was no mention of lots several requirements. If the OP didn’t state all detail lines will be the same height, it’s good practice to assume there may be growth (and then ask).

I don't believe you can create a union query with SQL like: SELECT * FROM Yourtable UNION SELECT A, B, C, D FROM Yourtable EDIT: I tried and this actually worked SELECT yourTable.* FROM yourTable UNION SELECT Null, Null, Null, Null, Null, Null,Null FROM YourTable; I also changed the name of...

A couple issues. 1) your record source is a table name with no field names. Change the record source to qselYourTable with a SQL view of SELECT YourTable.ID, YourTable.OrderNumber, YourTable.StopNumber, YourTable.CustomerName, YourTable.PONumber, YourTable.ItemNumber, YourTable.ModelNumber FROM...

Merry Christmas from MinneSnowta where we are blanketed with the white stuff.

The code worked for me as posted in #1

Have you considered a multi-select list box rather than a form?

I realize his naming choice based on my pleading for a simple example. Be careful what you ask for.

I would prefer to have my name on dialogs other than errors.

Since the BE is SQL Server, you should consider using a solution that puts the work in SQL Server like a pass-through.