Search results

  1. S

    Question AutoNumber Fields for data.

    Thou shalt not use Autonumber if the field is meant to have meaning for thy users. Can someone clarify that? I mean some examples of when/why it is wrong to use an auto-number field?.
  2. S

    Question Report Broken Hyperlinks?

    We have a lot of older parts that have changed names over the years. Many of our hyperlinks are broken or the wrong format. Is there a way to find / report broken hyperlinks? I'm not sure if this would be a query of some kind, or VBA script module. I am just trying to figure out how to...
  3. S

    Question Using Bar Codes and Access for Student ID and Attendance

    a) Yes. b) No. Less expandable for sure. c) Depends on your computers. (We went with a cheap $30 scanner since we didn't need wireless). Simply put, all you need to do barcode scanning is a free Code 3 of 9 (aka, code39) font. When you print onto ID Cards you would do something like...
  4. S

    Split Database Hyperlink Fix?

    I got it working now. =) UPDATE [table] SET [field] = replace( [field], 'String1', 'String2'); Using the above mentioned strings. Access displayed some warnings, but the links are now working.
  5. S

    Split Database Hyperlink Fix?

    The hyperlinks should point to a common area on our server. Sadly, at the moment, they do not. I'm not sure how to fix them though, at least not in a realistically easy manner with an update query. Basically an update that checks IF( IS NOT NULL, and NOT LIKE "*M:\Database\Drawings\*" ) Then...
  6. S

    Split Database Hyperlink Fix?

    I inherited an unsplit DB at work. It's been running very, very slowly lately. I did a compact and repair and that helped. I have now split the database into a front end and backend. That has helped a bit as well, but I noticed the hyperlinks are broken. Our item master table had a link...
  7. S

    Access 2007 switchboard only

    Is there as way to create an ACCDE where Access auto launches the switchboard on start up and hides/disables access to everything else? Is there a module/macro to enable/disable this mode? So I can take my development ACCDB, run the lock script, and then convert to ACCDE. Unlock again, and...
  8. S

    Help with INSERT/UPDATE on unbound form.

    Thank you for that. I've gotten it to work now checking for nulls; and also allowing ' and " in the notes and scrap reasons. So the basic system will at least function. :) I'm honestly not sure how to accomplish what I want using a bound form. I don't expect the employees to remember...
  9. S

    Help with INSERT/UPDATE on unbound form.

    I am working on a time ticket database and am having trouble with the form / VBScript. I wanted to make a 'smart' form (my first mistake :banghead:), but I am having a lot of trouble for something that should be really simple. I've attached a zip archive including a picture of the table, and...
  10. S

    Need Advice for Job Timestamping

    Google Search "Access run query daily" first response "Scheduling a Daily query to run at midnight - Microsoft Access / VBA". I swear it reads minds sometimes. Being able to close accidentally open jobs is the only thing I can think of that would be a big issue to data entry. Other things can...
  11. S

    Need Advice for Job Timestamping

    If the system automatically handled it - If open job exists, close it (filling in StopTimeStamp, qty made, qty scrapped, etc.). Else, insert new record. How would you handle forgetting to clock in or out of a job previously? My guess is to have a report that prints difference between...
  12. S

    Need Advice for Job Timestamping

    Currently, the Yes/No is a check box. The user would scan the proper bar code on the job form (entering Job#, Department #, Operation #). Then check the start box (or leave it blank if closing a job), select user, etc. This creates 1 entry per start and 1 per stop. Which is largely the...
  13. S

    Need Advice for Job Timestamping

    I'll start off by saying I am unsure if this should be in tables or queries section of the forums. In case it matters, I am using office 2007 (accdb format) for the sub database I am working on (which links to an office 2000 mdb format, for a few fields of information -- some of the id's are in...
  14. S

    Hello from Michigan

    I've been programming for a while now mostly for fun. Recently, for work, I've been asked to do more and more database work, all in access, so I figured this would be a good place to go. I keep coming here anyways, my friend Google keeps pointing me here. :D I enjoy video games, programming...
Back
Top Bottom