Search results

Again, thanks for the replies. My main concern is that somebody gets into the BE just once, views the passwords (stored in a users table) and then can log on as somebody else from then on... the chances of somebody picking that up will be pretty remote unfortunately. And the threat of...

Hello all, I'm struggling to come up with a recordsource for a report in the following circumstances: Employees work on Shifts, each shift has multiple deliveries, each delivery is to a certain district. What I need is a report grouped by district, showing the employees who have NOT made a...

Thanks for the replies. With certain people happy to download 'point-and-click' software to crack Access passwords with incredible ease, I thought I must be missing something on the security side of things. But sadly not!

Thank you for your reply. I'm sorry I missed the user group meeting; I've been away for a few days. I will certainly keep a look out for the next one. Regarding my initial query, I am now wondering if I'd be better off migrating at this stage (before going live) to a better solution for...

Resurrecting an old thread... With a similar conundrum to the initial poster, am I correct in saying that if you are trying to protect data in the backend there is little point in adding shift bypasses, hiding the navigation pane etc. You might as well just password protect the db. If somebody...

Spot on - all fixed now! Many thanks

Thanks for the reply. Lets say 0000 is entered in the textbox tbEntryBox: Dim strEntry as string Dim strUpdate As String strEntry = Me.tbEntryBox debug.print strEntry 'this shows 0000 strUpdate = "INSERT INTO tblLog (strValue) VALUES (" & strEntry & ");" DoCmd.RunSQL strUpdate And the...

*Solved* Problems keeping leading zeros Hello all, I have a problem trying to keep leading zeros. The entries in a text box can be numbers or text, and are not of a fixed length. I want to store the entry into a string variable, which ultimately gets used in a SQL INSERT statement (into a...

Hello all, I have a split Access 2010 database with plenty of VBA. I've been reading up on my options for sharing this over the internet (cheaply and easily, without losing the VBA, and probably without the need for any concurrent users)... am I correct in surmising that the only sensible...

I am passing them as objects, and 'is nothing' worked perfectly. Thank you both very much!

I have a function which has several optional arguments. These arguments are either forms or controls. I need to test for how many of the optional arguments were passed. I can't use IsMissing because they aren't Variants. If I make the optional arguments variants I get a "ByRef argument type...

Thank you for the reply. To give a little more detail: The continuous form shows employees from employee table. In amongst various employee table fields such as date of birth, contact details etc this subform also draws in information from various other related tables. For example, one...

Hello all, I've been trying to filter and sort a continuous form on the basis of the value of a textbox in each row. The textbox's control source is a VBA function, which is running an SQL statement. This has not been very successful! Before I chase my tail even further on this one, am I...

Hi, thanks for the reply. The problem is that every time a change is made to the datasheet (such as a column resize or a filter) it prompts you to save your changes when you navigate away. This only happens when using the navigation subform ('07 / '10). While the problem seems reasonably well...

Hello all, I am looking for ideas for an alternative to datasheets to achieve a continuous subform within a continuous form. I'm steering away from datasheets if at all possible because of their behaviour within a navigation control (persistent save prompts). The basic set up is: Each 24 hour...

Thanks for your reply. I thought about what you said, and created a calculated field in the table that converted the time difference to decimal: Hour([ShiftDuration])+(Minute([ShiftDuration])/60) I then ran the SQL based upon that decimal figure. The result was exactly the same. So then I...

I am having some strange results using orderby on a form. The set up is a simple combo box of column headings, with some vba to order the form according to the appropriate heading selected. This works fine for the fields with names, numbers and dates. But I am getting some strange results when...

Edited because I found a solution Here is the test data: Employees (companyID, LastName) 001, PersonA 002, PersonB 003, PersonC Shifts (shiftID, Driver, Loader, ShiftDuration,DaySheetID) 01, 001 (PersonA), 002 (PersonB), 01:30, 1 02, 003 (PersonC), 001 (PersonA), 00:45, 2 03, 002 (PersonB)...

Hello all, I'm struggling to get an SQL statement that works. Most of my (very limited) SQL knowledge comes from using query design and then switching to SQL view. That has got me through most things, but this current table design is stumping me. I've attached a simplified copy of the table...

Thank you for your help. After playing around a lot with domain aggregates and recordsources, I think the best approach is a function returning a value from an appropriate SQL statement, then setting that function as the controlsource. Now I just need to figure out some disambiguation on the...