Search results

How could I use the autonumber for that? Wouldn't I still end up with the same problem? I won't always know how many total records are in the DB...or the limit to set the autonumber for. But I'll play around with it on a temp table and see what I can do.

Weekday(Date()) will return a number, 1 = Sunday, 2 = Monday, etc. But that's only if you start with a valid date, not "Mon", "Tue", etc.

Not really. But this can help: http://www.mvps.org/access/modules/mdl0055.htm

I don't think you should have a list of logins at all - not viewable by the user. Just have it come up and ask for a password. Use either the fOSUserName function you have or Environ("UserName") to get the current logged on user and then when they put a password in and hit okay, compare that...

I didn't know you could create a custom one. I haven't used it all that much, just enough to know that I don't like the ribbon...or at least the default one. I hate it when they move things around. But my company is still on 2003. Would be quite expensive to do the upgrade for the number of...

I've used 2007. I don't really care for what they have done moving things all around, and I hate the stupid Ribbon crap that they put in all the new O2K7 apps.

The account numbers have a range, but to get the unique range you would have a possible value from 4,000,000,000 to roughly 635,000,000,000. The second part of the account number is not necessarily uniqe but even then you would be talking about a range of anywhere from 900,000,000 to...

Try putting your code in between: Private Sub Form_Current() End Sub

You could do it using SQL for your recordsource, and the different boxes change the WHERE clause. I can't look at your example as it's in an unrecognized format.

Yup. Except the only issue is if someone moves them.

nevermindasdf

When a record is completed, that completed field needs to be used to exclude those records from being selected. I don't have record ID's. Well I do. There are two fields which hold parts of an account number. Both of those fields are set to primary keys so as to prevent duplicates from being...

What if you grouped the order numbers and sorted them Ascending as well as sorting the date/time ascending? That should give you the order numbers all together, with the oldest record first. You still run into the Next Record thing.

Well first your time data is not in a standard date/time format, so it isn't something that a built in Access function could evaluate. You would need to convert the fields to a standard date/time format before you imported to access - or have some code that does this during the import. Then...

I need some help getting random results in a query. I have this so far, and it works, but it is slow. SELECT TOP 1 tblMain.Field1, tblMain.Field2, Rnd(tblMain.Field2) As Expr1, ... FROM tblMain WHERE tblMain.COMPLETED=False ORDER BY Rnd(tblMain.Field2) DESC; This does a great job actually...

lol....I'm a moron. Of course. I totally spaced on that.

Okay so I have a form that is causing problems somehow. I have a data table that has currency values in it. There is a field on the form that adds and subtracts some of what is entered in order to determine if an account can be archived. Basically it's for following up on some collections...

I have a DB with employee info - it has info on days off. I would like to create a report in the form of a calendar which would show the current month and put down the names of employees who have scheduled time off - so people can see at a glance who from their team is off and when. Does...

You can never truly secure an access backend file - you can get it good enough, but the only way to completely secure your data is to use a SQL server and user permissions.

I use an MDE file and disable viewing the database window that shows the objects. I use a startup form which shows application name, etc. Then I use a custom menu bar at the top. The menu loads based on an access level assigned to users in a table. If they don't have high enough access, say...