Search results

I got this cool function to convert fields to sentenance case, so I created a module name caseModule and pasted the code in. Public Function sCase(ByRef strIn As String) As String Dim bArr() As Byte, i As Long, i2 As Long If strIn = vbNullString Then Exit Function Let bArr = strIn Select Case...

The calendar is used to capture the beginning and ending date, the calendar uses a query.....

I need to create a db from a very large excel spreadsheet (currently 180 rows, and 2 columns for each day of the week) Attached is a screen shot of all the fields. Ea day there will be 5 entries (one for each plant) for all values in the common field. In addition each plant has to enter info...

I'm still using 97, I have a report with a pie chart in the testing phase it works (shows the correct perentages fine), but as soon as I tested it from the switchboard the pie just displays 100% - incorrectly. FWIW the switchboard open to a calendar and the calendar opens the report. I've tried...

thanks, I forgot about the poor choice in field names...anyone else can you provide me with some assistance?

Thats why I asked for assistance....so each field becomes a table? what type of relationship would you suggest?

Attached is a screen shot of all the fields. Ea day there will be 5 entries (one for each plant) for all values in the common field. In addition each plant has to enter info based on the process that they run; eg Fla (plant) my run 4 different processes (process field is in the tblManuf. My...

Could someone offer me some advice, I need to build a db w/tons of info and I'm getting confused the more I read about data normalization.... I will have 5 plants enter a ton of data each day -date- (#25 staffing numbers; #10 quality numbers; #5 customer service numbers; #50 production numbers)...

What are the benefits of each a stored query or sql? I suspect that the stored query would run quicker>

I can Monday, its a work thing; I thought the exit sub would stop it, then I tried the docmd.cancel event. thank you

yes it fires!

The message box, is the one in my code: MsgBox "Email notifications have been sent", not sure if that's what you meant

I replaced the if isnull(ctl) then line w/ if nz(ctl,"") = "" then and the email still gets sent, seems there has to be a way to stop the command on click event to validate

Sorry, the email messages are being sent with missing information

I thought it was working, but it's not...this is my code on a command button: The ctl.Tag = "Required" on a the combobox, does anyone think it make a difference? Private Sub cmdSendEmail_Click() 'ea of 3 controls under properties: All: Tags set to Required Dim blnContinue As Boolean Dim ctl...

clarification sorry to be stupid, but where would Exit Sub get placed at?

Can someone help me out here, I have db a few w/required fields and a command button that sents out a simple email msg from a module. Problem is users are clicking the email button when all the fields aren't being filled in. How would I code it so this doesn't occur? This is my code on the...

you are correct TblNewCustomerConern.Plant is a plant name not a id. In your opinion would this work if I created a table for plant w/ID and reconnected it? I tried the 3 query method, w/query 2 being the posted sql and query one being the plants. I used the left join with the instruction and...

Thank you SELECT TblNewCustomerConern.Plant, Count(TblNewCustomerConern.ConcernNo) AS [The Value] FROM TblNewCustomerConern WHERE (((TblNewCustomerConern.DateReceived) Between #1/1/2008# And #12/31/2008#)) GROUP BY TblNewCustomerConern.Plant, TblNewCustomerConern.Deleted HAVING...

The 2 queries didn't work. I tried all kinds of joins and it messed up the data