Search results

Most definately-- You can do that with a table too. Just as jazzscreamer said.. 1) Put a combo box on your form 2) Goto the combo boxes properties Data tab (This is where it differs.) 3) Change Row Source Type to Table/Query. 4) Then set Row Source to something similar to: SELECT...

My brain has shut off... my only answer is: With VBA! This thread will help you understand how to navigate and edit items in a recordset. You could maybe use a macro too. SetValue.. ? I might be wrong on that one.

Tools -> Database Utilities -> Convert Database -> To Prior Access Database Version... Of course, you may need to revise things since it may not convert everything correctly. Good luck!

Timber! :p Use the criteria "Is Not Null And >0" for it to work.

Did you set a record source too? You probably have to be more specific. VBA doesn't know where [CustomerLast] etc are coming from. try something along the lines of [TableName]![CustomerLast]. Understand? What is the point of this VBA code? If a query already does it, why do it in VBA too?

TimeFrom & TimeTo are date/time format? If so, =DateDiff("n",[TimeFrom],[TimeTo]) will get you the minutes between the two. That help?

Heh. Since most free web-related services (aim/hotmail/etc) don't allow someone to register an account starting with a number. I represented the first ZERO with an "O". In binary, 1110010 would actually be a negative number. To be positive, it must start with a zero. To represent a character, it...

Investigate into TableDef & Fields. Using them along with items such as .Name should get you what you wanted. If you take a peak at this thread's first response. The code he uses to capture the field name is as simple as fld.Name. (Of course after he declared Dim fld As Field) And raskew got the...

You can go that route. Easiest if you plan on storing the batch file in the same directory that the database file will be. However, it is possible to have a batch file perform a search to find the database. I recommend putting the batch file in the same directory. If that's the case.. copy...

Hm. What is the significance to these records? If you explain in more detail, maybe we can whip up some VBA you can use.

How about.. On Lost Focus? On Update?

If the data is in a table or query.. you should be able to get these values you are looking for if you... create a query, then click the totals symbol to make it into a total query, you should get what you want after grouping by division. To do this from a form's textbox values.. yes, you will...

You're welcome. Glad you got it resolved. :)

ghudson already provided you with the most adequate reply. Yes, it's VBA code and you may be weary but there really is no other way around it; No "Access" related option. You can search for more examples or help files with InputBox if you want to understand it more. Good luck!

You'll probably want to leave the wizard behind and implement VBA. You can solve by combining how to Navigate a Recordset and how to send email from VBA code. Refer to the two links to help you get started. (If the second is insufficient, you can search the forum with "send email" for other...

See if changing "Cycle" (In the Other tab) to Current Record or Current Page.

Ah. Then I expect you will have to go with creating your own security. I know there are two threads that have samples uploaded on here. I cannot find the second post but here is one. http://www.access-programmers.co.uk/forums/showthread.php?t=64220 (Look at post #3 at this above link.)

Yup! Change startup based on user Here are two others that may be of use but I am pretty sure that first link will do it. http://www.access-programmers.co.uk/forums/showthread.php?t=63677 http://www.access-programmers.co.uk/forums/showthread.php?t=63720 Good luck!

Fair Thee Well ChrisO, Sounding a bit Aussie? :D I'm using Access 2000 but I have no doubts your Access 97 demo works. I am trying to use this as a learning experience so I am a bit weary to just be satisfied with working code. That make sense? At any rate, you are correct. I have mentioned I...

You are correct in that there is no specific forum for Security. My guess is the General Forum would have suited this thread better. I doubt anyone will string you up for the error though. :p If you search the forum, you will find some threads that already deal with Security. I've been told...