Search results

  1. GLese

    SetValue and Now() failing

    As for the members here, YESx1000000!!! Y'all are far better than some of the other forums I have dug around on *coughcoughStackOverflowcoughcough* For the modules part, I have some code that will work on a few forms I'm building, so I'll go the modules route. If I make a module that is not...
  2. GLese

    Combo Box in Split Form not updating record?

    I created a split form (see attached image) to allow people to logout paperwork that has been entered into the database I'm building. The idea is to allow the people completing the paperwork (or sample testing once I get around to those forms) to select which paperwork they have finished and...
  3. GLese

    SetValue and Now() failing

    After seeing how it converted, I decided to start from scratch and teach myself how to code it to do what I want, rather than relying on the auto conversion. I figure this will benefit me in the long run better if I can learn to make my own, clean code
  4. GLese

    SetValue and Now() failing

    Okay so thanks to everyone (Minty and BigHappyDaddy) for the push to explore VBA. I'm learning the basics of coding and this seems to be a much better route! So before I close this thread out (since I'm taking a different route) I have two questions: 1) Do y'all have any recommendations on...
  5. GLese

    SetValue and Now() failing

    I'll throw this out there while I am doing some research on my end into a VBA option... (In case someone knows a quick fix) If I use the built in "Convert Macros to Visual Basic" button in Access 1010, it gives me the following module: Option Compare Database...
  6. GLese

    SetValue and Now() failing

    I'm not well versed in macros OR VBA, so I'm open to learning either one. I've heard a lot of good things on VBA, and have used a little bit in MSExcel, but I'm definitely a newbie when it comes to all this. Thanks for the advice and encouragement!
  7. GLese

    SetValue and Now() failing

    Pardon my being so new to the terminology, I'm not quite sure what you mean by data macro. What this macro is supposed to do (and did up until whatever threw a wrench in the works) is timestamp the specified field for the record being created/modified by a form. Ex: I have a form for...
  8. GLese

    SetValue and Now() failing

    In order to make a timestamp in several of my tables, I have built a macro based on a post on the Microsoft office support page "Store the Date and time when a record is modified" My Macro is: SetValue Item = [DateTimeIn] Expression = Now() CloseWindow Object Type...
  9. GLese

    Question Calculating Turn Around Time

    Our current model accounts for company holidays (which I figure I can add in every year using another table that provides the data for a function) I'm wondrign if the function you use couldn't be modified for our use. Out TAT can range anywhere from 00:01 (hh:mm) for samples that require...
  10. GLese

    Question Calculating Turn Around Time

    Thanks for the link, I'll get looking into that. As for the data storage, That's how we had it setup in the previous system (which has been phased out, not an access database, just a plain spreadsheet). I don't have a problem changing up the data storage so it is all the same format
  11. GLese

    Question Calculating Turn Around Time

    The database I am designing needs to be able to calculate the turn around time (T.A.T.) on samples being processed. Each record in the main table will have a lot of data for each sample, but the times that are being recorded are in three fields: DateIn (Will autopopulate when the record is...
  12. GLese

    Database Chemist

    Hello from South Carolina, USA! I am a chemist at a manufacturing facility who is new to using Access. I am developing a database for us to track our samples as they are brought into the lab for testing. When I'm not on the clock I am spending time with family (wife and two dogs), or...
Back
Top Bottom