Search results

If the temp table has no primary key, any query using it will be read only. Fine for reports and lookups but a problem in a form.

Long ago I create a lookup form and function to make this type of input easer. The call would look like the following Lookup("Report A;Report B;Report C",1,1,"1in","Select Report",True) It can also take a named query or a query string plus paramiters.

Use message box strDocName = inputbox("Enter Report Name","Report ID:" & me!recordid,"Report A") A custom form with a combo box listing all the valid reports would be better for the user.

Something like the following? tblAccount IDAccountNameDescription tblTransaction IDDescriptionTransDate tblPost IDTransID(FK)AccountID(FK)CreditDebit

I originally made the mistake of doing negative amounts, luckily an accountant put me straight and showed me how to do reverse postings. I always had a credit an debit column but had them in the wrong order.

I still don't like that structure; it encodes information about the account type in the table name. IMO have a single account table and an attribute table. One of the attributes would identify how the account is used. Only columns shared by all accounts would be in the account table. Now the...

I think it should be row for each type of account not table.

I ran into an issue yesterday trying to connect to a VERY old HP4050's web page. The internal controls do not show. I enabled IE emulation for the page but the option to go to IE mode is not visible. Could the recent W11 updates finally eliminate IE thus causing the problem with the IE control...

I posted earlier about using shadow copy and server backups. The consensus appears to be that it can be un-reliable if the BE is open during the backup. I have used shadow copies to recover older versions of the BE to restore data changed by users. I have not had issues but others say I was lucky.

Clean backups are always an issue. I have users, some of them upper management that constantly leave computers logged in overnight with multiple programs open with multiple network files open, including Access FEs. The shadow copies and backups tend to work. I always do a compact/repair after...

Sub TestNull() Dim A, B, C A = 2 B = 3 Debug.Print VarType(A), VarType(B), VarType(C) C = Null Debug.Print VarType(A), VarType(B), VarType(C) End Sub TestNull 2 2 0 2 2 1 0 -> Empty 1 -> Null 2 -> Integer

If you are talking about OnDrive then turn off backup of Desktop, Documents and Photos, which OneDrive turns on by default. Then don't store anything in the OnDrive folder. Office365 will autosave Office documents stored in OneDrive, not storing those documents in OneDrive will disable autosave.

I don't believe you can index a long text column.

Enable shadow copy and set the times you want the drive hosting the FE backed up. You can then use previous version to restore you FE to about any date. Now use at least Windows backup to do daily backups of that drive.

Add an equal before vbYes bInformation+vbYesNo) = vbYes Then

Gold is tangible, but is not wealth, it's a commodity, same oil and crops. Adam Smith's Wealth of Nations, explains gold as an exchange currency. From AI In One Sentence Adam Smith believed gold is valuable because it is costly to produce, physically suited to serve as money, and widely...

I have a friend that grew up in the Seattle aria. He camped a lot with the BSA and told me he never had a trip were it didn't rain.

I would add a single transaction record getting it's primary key. With that Key add the 2 lines to your transfer table, passing the primary key from the transaction table to be used as a foreign key. The transaction table holds the date of the transation. The amount column is not needed because...

The data copied from the linked table will be current assuming it's not locked by another user editing it. It may not be current a second later, which is a good reason to NOT duplicate data. If the user is viewing the data in a form and the from has a record selector bar; Access will display an...

The problem with using the Outlook calendar is New Outlook. I assume any automation to show the Outlook calendar will fail for anyone using new Outlook.