Search results

Hi, if you see these messages all of a sudden in a Db that was working fine before, I would recommend doing a Compact & Repair routine before anything else. If that does not solve the problem you need to find which of the indexes allows no duplicates, starting with the primary key. If you...

It looks more like [Serial Number needs to be presented as a number i.e. ..."[Serial Number]=" & Clng(SerialScan)) Cheers, Jiri

You are welcome.

Function FlexDays (EmployeeDateofHire as Long) as Long If Year(Date) > Year(EmployeeDateOfHire) then FlexDays = 6 Else Select Month(EmployeeDateofHire) Case < 5 FlexDays = 6 Case < 9 FlexDays = 4 Case < 12 FlexDays = 2 Case Else FlexDays = 0...

Few things, Pat. I wrote my app for the Canadian market where the lease regime is standardized and must conform to the Landlord-Tenant legislation. Not much opportunity to force tenant into a new term of lease, for example. The lease extend automatically after a year and becomes a monthly...

The solution depends on your business rules. My rental application has each apartment rent schedule (not a tenant but an apartment table!). Scheduled rent increases are automatically implemented in a receivables run at the beginning of each month. When the month of rent increase becomes current...

What @Solo712 clearly sees is that if you want to complicate things in Access, or any other software development platform for that matter, there are definitely opportunities to do it.. ;)

Hi, there is a nifty custom treeview that I have been adapting for my programs. You may want to take a peek. Best, Jiri

Simply put, constants cannot be used that way. They are numeric or string literals. Use TempVars as arnel suggested or a parameter table to carry the LogCustID content. Best, Jiri

Hi, Colin. Just to let you know that I posted a new thread in Sample Databases, Basic User Security. There is one attachment. Please, check it out. Thanks, Jiri.

Hello everyone, With the advent of the accdb format in A2007, setting up user security has become the developer responsibility. Luckily, to provide basic, “lightweight” security is not a difficult task. It consists of managing a database user table and providing the application with a login...

No Arnel, the OP was quite clear. You need to compare the date text box with reference to the current month, and determine whether it falls to next month. DateDiff or the DateSerial as KityYama constructed it are the ways to go. Best, Jiri

Or simply RecordCount = DCount("*", "tblP", "[PN] LIKE '1ABC*'" )

Select Case [Field1] Case 'value1', 'value2', 'value3', 'value4', 'value5' MsgBox "Message for User" End Select Cheers, Jiri

Hi Matt, though there may be issues with referential integrity in splitting the BE (if related tables end up in different files), there may also be benefits in performance and controlling the size of the back end(s). I use a cascaded switchboard which basically addresses the BEs...

I have checked an old application of mine with an API function which forces an Access popup form on top of all other windows. It does not conserve the focus but you may be able to use it for your setting. Simply click on the Access form control that you want to continue with. ' ' Make sure...

The point to get here is that when you execute the Shell command the focus is passed to that program, and Access has no control over the display run under Windows. My guess is that with the web browser control you could take the focus elsewhere but I have not tested this. Jiri.

Hi, if the setting of some form controls changes from one record to another you should use the Current event. As for settings differentiating between new and existing records I prefer using the NewRecord property, i.e. If Me.NewRecord Then ... Else ... Endif Best, Jiri

Not clear whether the corruption originates in the the Master FE or after distribution to users. If the latter, do they all get same errors relating to corruption ?

IIUC, to follow up the quantities of the products in two locations after each transaction then your "history table" has to indicate which location the transaction relates to. Then you can calculate the new balance of the product, in the Vault and the Cabinet separately by creating a field for...