Search results

Tartarik - I was looking at the diagram and noticed that you have broken one of the Ten Commandments for developers. There are spaces in the field names. This will lead to a bit harder time coding further down the line, having to use brackets and such. At this point in devlopment, you may...

That is why I like this forum, all different options are explored. Thank you! dtDueDate = CDate(dtDueDate & " " & dtMaxTime) worked great!!

Thank you for the article, however I don't think that it covered what I need, or I may be a bit dense :) If I have a date (dtDueDate) as mm\dd\yyyy and I want to add to the end of the date a time (dtMaxTime) as hh:mm:ss AM\PM so that I finally come out with mm\dd\yyyy hh:mm:ss AM\PM, how would...

I have a variable (dtDueDate as Date) showing as 6/28/2013. I want to append a time value to it (dtMaxTime as Date) which is 5:00 PM so dtDueDate reads 6/28/2013 05:00:00 PM. I have been going in circles trying to figure this out. My goal is to append this date to a table field which has a...

"((tblEmplData.EmplNum)=meNum) AND ((tblReviewPerf.ReviewName)=" & Chr(34) & _ should be "((tblEmplData.EmplNum)= " & meNum & ") AND ((tblReviewPerf.ReviewName)=" & Chr(34) & _

Try going into the recordsource property of the report. If the fields are not in the QBE grid, then you can add them there.

I created a Users table on the front end and I have a function that looks at the user table for the user ID and assigns privleges. I use the TempVars collection. tblUsers userID (PK) AccessDev (boolean) Access Supv (boolean) Access ReadOnly (boolean) I then assign the TempVars!AccessDev to...

I would import to a temp table and do the update. Join the temp table to the data table and match the PK's to perform the update. Then run the append from the temp table to the data table

what Fields have potential NULLS for the Insert statement? are you looking to have the zeros in Me.txtRepairCogTotalDefVal?

Me.txtRepairCogTotalDefVal = NZ(rs![sumofTotalDeficit],0)

try NZ(fieldname, 0 ) wrap all firm field names in that like NZ(Me.txtOddCogTotalDefVal.Value, 0)

what did you see in the immediate window on the debug.print? If you see something there, copy it, paste into a query in SQL view and try to run. If there is an error, access should place a cursor in the SQL at that pont.

I may want to chime in here. PBaldy, is is good to teach a man to fish... so lets give 'em some bait... if the values that are in the text boxes are text or date, they must be surrounded by qoutes (for text) or hash tags (for dates). Careful for Nulls too. Hit ALT+F11 to go to the editor and...

What is the query name that you are using and what are the field names that you are outputting to excel in the query?

you have to place the name of the query that you are using there. In each of the rs!fieldname statements in the code, make sure that the fieldnames match the ones in your query.

Ahhh yes. Forgot about that part. In the VBA editor, go to tools>refernces and look for Micrsoft Excel xx.0 Library. If the references oprion is greyed out. Sotp the code that is running and try to go to references again.

change the name of page2. this should work page2 is the name of the tab. Dim ctrl As Control For Each ctrl In Page2.Controls If ctrl.ControlType = acTextBox Then ctrl.Enabled = False End If Next ctrl

I use this combonation of functions. works well for me. In outlook you must also set trust center to allow programmatic access. Option Compare Database Option Explicit Dim appOutlook As Outlook.Application Dim ns As Outlook.NameSpace 'this function opens a recordset to see if there is an...

User Defined error is usually a missing reference. Create a reference to the Outlook libraray in the VBA editor by going to tools>references. Look for "Microsoft Outlook xx.o Object library.

yw. refresh this post. I made an edit a minute ago becuase there was an error in the there. :( don't want bad code floating out there!