Search results

Rather than all this password stuff, just authenticate based on their Windows logon (username). So, two tables: tblUsers UserID [Autonumber, PK) WindowsID Forename Surname UserLevelID [Number, FK] etc. tblUserLevels UserLevelID [Autonumber, PK) UserLevel Then a query that joins these two...

http://www.microsoft.com/resources/msdn/goglobal/default.mspx?submitted=0425&OS=Windows 7 Does the Microsoft Help on the Format() function - in Estonian - use the . or / method? Seems it's somehow down to regional settings.

Hmm, I forgot the # delimiters, although I would expect to see a Type Mismatch error rather than a Syntax Error. This should fix that part: [Date_Added] = #" & Format(CDate(Replace(Me.Date1,".","/")), "MM/DD/YYYY") & "# And [Shift] = " & Me.Shift) If it does, then the issue now appears to be...

Your issue is: OpenForm.sales orders Should probably be DoCmd.OpenForm "Sales Orders" Basically, it thinks Sales is a method of the OpenForm command and Orders is a parameter you are passing to it.

Reading through all this again the issue is likely lying with this dot-based date represenation. While you say that . is the Estonian format (over /), we are seeing that / works in the Immediate Window. People type in 02.04.2015, which is generating a Syntax Error as Access doesn't recognise...

Perhaps a bit more complex, but one thing I do i: 1) Have a User table. One of the fields in this will be the user's Windows ID 2) Have a query on the User table, where the criteria is based on the Windows ID (see fOSUsername() function - google it!) 3) Create a User class with properties that...

Okay, it's solved, but how about this as an alternative solution? It uses a class module - so if you want to time multiple things throughout your database you need only code it once - and can return the elapsed time in hours, minutes, seconds, or milliseconds. Basically, create a new Class...

Listbox showing all users and its multi-select property on. Then you can loop through its ItemsSelected property and add users to some other list.

Can you post a screenshot of your table '249_1_CHours's design view? Also, what on earth does that table name imply?

Surplus " :o [Date_Added] = """ & Me.Text27 & """ And [Shift] = " & Me.Text29)

Re: Change font color on ALL form controls on "Got Focus" and "Lost Focus" This is the method that I (would) use. I use a variation on it for changing the backcolor property of textboxes and comboboxes, so that the user can see what item the tab is at and needs data input.

I would only use them on lists that were strictly defined and unlikely to change, such as Months or Days of the Week. Everything else I would drive through a database. This method you can take future development out of the equation by, for example, building an administration form that allows...

For anyone looking into this, here's the discussion that the code has come from. http://www.access-programmers.co.uk/forums/showthread.php?t=185030

Perhaps something like this. tblEmployees EmployeeID (PK) Forename Surname Email StartDate EndDate ClearDate NOTE: Active as a Yes/No may be okay, but you can get more information from a Date. For example, if the EndDate has no date then the person is active. But with dates, you can query on...

So: "[Date_Added]= " & Me.Text27 & " And [Shift] = '" & Me.Text29 & "'") You have a field called Date_Added, and a treating it numerically. Yet the output is 4.02.2015 , which looks like a Text field as it's not a date (slashes not dots make dates!). Then you say Shift is a Numeric field, yet...

If Me.Business = "TYPE 1" Or "TYPE 2" And Me.Case = "Sent Email" Then Should be: If (Me.Business = "TYPE 1" Or Me.Business = "TYPE 2") And Me.Case = "Sent Email" Then Note the brackets to group the OR together, otherwise your logic would be like this Me.Business = "TYPE 1" OR Me.Business...

You could just do this: If StrConv(Me.Business, vbUpperCase) = "TYPE 1" And Me.Case = "Sent Email" Then

It could be, but that would be counter-productive. Ideally you would not want to do the rework on the database each time a new business or whatever, was added. Going by code, you would then have to hard code in the new business each time. By putting the data in a table - and, after all, it is a...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55729

Actually, just reading your example, which is a little different from what I inferred from the start (That should teach me to read the whole thread!) What you're after is Cascading Comboboxes. There's are thousands of examples of these on the forum, if you do a search.