Recent content by SuePee

Thanks a lot for the help. We seem to be having a bit of trouble with the network today. I sent all the info earlier, but now it does not show up. So here we go again. The relevant number is the Lab No. That is where I want the new control number to be inserted into the form and consequently...

No, I want it to be in the format 08-185-01. My mistake on that one,I copied the code from another post where he wanted the first digit to be 48. Also on the code from Golom, it is telling me ther has to be an "End Function" line in the code. I was calling this number "Lab No". Do I need to...

Good Morning, I must be dumber than a box of rocks! I cannot get this to work. I am certain it is something I am doing wrong. Here is what and where I copied in the code: Option Compare Database Private Sub Form_AfterInsert() Me!ControlNumber.DefaultValue = """" & NextSmartNum() & """" End...

REF: thread701-1454746 I am trying to create a smart number for a user. Currently they are using this system manually and have been for years. They want the "Julian" (Ordinal)date to be used in this format:Year-Julian Date-sequential number. EX: 08-185-01 This would signify that the report was...

I am trying to do the same thing with a database. I want the "Julian" date to be used in a format:yy-000-01 EX: 08-185-01 I copied the following code and all I get is a blank field. I don't even get the error message. I never had any programming training and so I am really challenged. I even...

PHV, Yes I tried this, but it didn't work. I think I am having a problem knowing what goes where. Going back to the original question: I want to add a new "Analyst" to a table called "Financial_Analyst". I am using a combo box that lists the current Analysts, but if one is not there I would...

The line that is highlighted is: Set rstAnalyst = db.OpenRecordset(sqlFinancial_Analyst,dbOpenDynaset) Thanks for any help you can give. Same Circus, Different Clowns

Hi all,Me again. I am still having a problem with a "Type Mismatch" error. Maybe this will help, I don't know but here goes. The table that the data entry form completes is called "Work Directives" and the table the info cames from is called "Financial Analyst". The item on the Financial...

Attached is my code (Copied from the internet and modified) for an Access 2000 database. I want to add a new "Analyst" to a table called "Financial_Analyst". I am using a combo box that lists the current Analysts, but if one is not there I would like the user to be able to add an Analyst. The...

We have an assembly line that rebuilds units. In order to get the correct parts to the line in a timely manner we need to know which parts are used in the rebuild. This way we can put a percentage of parts (like 67% of the time we need a new thing-a-mabob) Then in the Bill of materials we would...

I have a database that keeps track of who completed which training and when it is due to be refreshed, etc, etc. Previously, the Cross Tab report was separated by department (Dept) now I want to sort it by Supervisor Code (Code). I copied the code and made the changes so that it related to my...

Hello and good afternoon, I read the request with great interest because I am trying to do the same thing. When I write the query now, I put this statement in the criteria "Like [Enter PM Name]". This makes a box pop up with a place to type the name. It works fine if the user knows how to spell...

This is where you would change the time from 5 minutes to 1 minute "Const IDLEMINUTES = 5" See below -Place this code in the On Timer event procedure... Private Sub Form_Timer() ' IDLEMINUTES determines how much idle time to wait for before ' running the IdleTimeDetected subroutine...

Hi Duane, et al, I have a problem similar to RNBTraining. I want to list the number of hours, the material, etc allocated for each month. So I have a subform on the Work Directive form where one enters the month and the allocations for that month, for that Work Order. But when I call that...

Thanks for writing back. I did not post the code because it is quite extensive and is spelled out in faq181-1432. However, I did figure out where I went wrong in copying the code. There is an If statement that the programmer had broken into several line for clarity. I did not realize that VB...