Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VicLavigne

    Problems converting Access 97 To 2000

    I understand now, but don't know why it is doing that. The easiest fix is to find the default system.mdw file on the computer, rename "system_old", and then move your "custom" system.mdw file into the same folder. Make sure that the new file is named "system". This is how I setup my access groups.
  2. VicLavigne

    Problems converting Access 97 To 2000

    I originally tried to create a shortcut to the db and reference the workgroup. That isn't working out because of how many different databases that we have running within our organization. BUT when I make the custom workgroup my default, it doesn't seem to "take". I'm not quite sure what you...
  3. VicLavigne

    Problems converting Access 97 To 2000

    Best method is to split your database into BE (backend) and FE (front end) as suggested. You can also manually open up your database in Exclusive mode by opening Access (by itself, not the database), then File / Open. Locate the database you want to open, click on the down-arrow next to your...
  4. VicLavigne

    Conversion Issues

    What is your specific problem?
  5. VicLavigne

    Time calculations problem

    "I put the expression: IIf([EndTime]>[Cut],[EndTime]-[Cut],(TimeValue("23:59")+[EndTime])-[Cut]+TimeValue("00:01")) In a field on my query. The query draws the numbers from a table where date fields are formated as 'general date'. When I run my report, I get a decimal...
  6. VicLavigne

    Time calculations problem

    rjnitke: I just tried it, and you CAN build this expression in a query for use in a report. Don't worry about using SetValue or other commands. You'll need to use the Expression Builder (or just type the command in) in the Field block of the query, and then add it into the report.
  7. VicLavigne

    Time calculations problem

    To F/U my suggestion: The suggestion by BobJackson: IIF([EndTime] >= [StartTime], TimeValue([EndTime]) - TimeValue([StartTime]), TimeValue([EndTime] + 2400) - TimeValue([StartTime])) will not work, at least not for me, because Access doesn't recognize 2400 as a real time value. That's why I...
  8. VicLavigne

    Time calculations problem

    rjnitke, it sounds like you are working on the same project I am working on. I have come across the same problem, and have a solution that doesn't involve entering dates along with the times. I use a combination of macros based on Expression Builder. An example is Procedure Time. Procedure...
  9. VicLavigne

    Linking Secured Databases

    "The only this is, is that now all of my databases, even unsecured ones, come up an ask me for a username and password on my pc, but on other users pc those unsecured ones don't asked for anything." I have my database security setup this way, and I prefer it because I can tailor the...
  10. VicLavigne

    Need help to automate selection of a form

    I was using the Expression Builder, and used IFF to set the value of a textbox based on CurrentUser() status. Like this: (IFF CurrentUser()="Admin", 1,0) + (IFF CurrentUser()="Victor", 2,0) + (IFF CurrentUser()="Mary", 3,0) So that Text5 would = 1 if Admin...
  11. VicLavigne

    Need help to automate selection of a form

    Rollilee: It's automated, or more precisely, its calculated based on the CurrentUser().
  12. VicLavigne

    Need help to automate selection of a form

    Thanks for the suggestions. I think I'll study up on VB. In the meantime, it would just be simplest to add some command buttons to the Welcome screen and adjust the security settings accordingly. This will work, but isn't as aesthetically pleasing.
  13. VicLavigne

    Need help to automate selection of a form

    mph1: No, I didn't use a wizard to create the Welcome form, I created it from scratch. The purpose of this initial startup was to greet the user, and provide a starting area to proceed to the next usuable form. The Welcome form has no input by the user, other than an Exit. I wanted something...
  14. VicLavigne

    Need help to automate selection of a form

    Here's what I need to do: based on the value of a field on my startup form ( this is [Forms]![Welcome]![Text7] and is a number) I'd like to have an automatic selection of the next form to open. So far, I have that the startup form (Welcome) automatically closes on timer, but I can't work out a...

Part and Inventory Search

Back
Top