Search results

I don't think I would agree with such a broad statement, Pat. While I am not sure about the merits of an unbound form in this case, I have found unbound forms the better (,and sometimes the only, ) solution in instances where you need programmatic control over the data presentation. At any...

Hi, the issue is simple. You placed the counter (Y) inside the timer loop which runs out on the first visit to the timer event and shuts down the timer. Both Eugene L-S, and arnelgp have corrected that by decrementing the counter by one on each visit. This way, the timer will be active for 50...

As the saying goes: "There are three kinds of people: those who can count and those who can't". Best, Jiri

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.