Recent content by skipit

Wayne, Thanks for the help. I will try it out and post back if I have any other questions. Is there any reading besides the help files that talk about these actions? Once again thanks and have a great day!!! :D Skip

Morning all, I am having some trouble grasping the idea behind Len, Trim and such (I think this is what I need to use). What I need to do is change the network login name into the db name for a Lotus Notes db. Here is the format of each: Network Login (I pull this into my DB and save as a...

Good morning all, I have found a solution for this problem I will list it below but first I have another question.... How do I not show a field if it's value is equal to - (minus sign)?? The code in the qry design grid is the same as my first question. Any help would be great. Now...

Pat, Thanks for the help. I read thru all the info I could find in the help files on concatenation operators & and +. I replaced all the "&" with "+" but I still get the same results. I have searched the forums and found a little help but have not found anything to do what I need. I...

Morning all, Thanks to help from this forum I have the following SQL for one of my queries: SELECT [qryMain2-17].JCI_PN, [qryMain2-17].JeffCityPN, [qryMain2-17].ProgramID, [JCI_PN] & " " & "" & " " & [JeffCityPN] & " " & "" & " " & [Desc1] AS PartNum, "Center ILD:" & " " &...

dgarcia, To convert the 2k version to A97 with Access 2k: Open the db. On the menubar goto Tools / Database Utilities / Convert Database / To prior Access Database Version. You will be prompted to pick the location and name of the 97 version of the db. HTH Skip :cool:

shakermaker, Try the following code in the On Click event of the textbox to have the time and date shown with a message box where the textbox name is txtWhatTime: Private Sub txtWhatTime_DblClick(Cancel As Integer) MsgBox "This box was clicked: " & Time & Date, vbOKOnly, "What...

Steve5, Try using the Date and Time function instead of Now(). I got it working using the following code. See changes in red. HTH Skip Private Sub Command508_Click() On Error GoTo Err_Command508_Click Dim DateTime As Date DateTime = Now() DoCmd.OpenReport "money"...

Glad to help! :D

Belsha, You need to specify the location of your file in the code. If you open the Contact form in design view and goto the on click event of the button that opens Word. Scroll down till you see the following code: 'Specify location of template strTemplateLocation =...

Forms property window Ice, If you are talking about adding bmps to your form's background open your form in design view and look for Picture in the property window. Click inside the Picture box and click on the button beside it and browse for your image. Most people say it is better to link...

Mailman, I used your first example. It does exactly what I needed. I added more fields to the qry, of some data I needed but left out of my post for typing reasons. I tried the pivot table but it gave me totals(may have set it up wrong). I have never messed with pivot tbls before. I think I...

Mailman, Thanks for the help. I will try it and see what it does. As for the field names that is something the test software does. I am in the process of changing this over in the testing software but having 300 or more test files to change takes a while. The test software is German...

Attached DB Mailman and others, Thanks for looking at this. I guess I did not explain very well. I have attached the requested zipped db A97 version. I removed all info that was not needed. I have tblGMT800 which is my table that the testing software uses to export the "Readings" which in...

Hello all, I have a table that is imported from some test software we use. We do a test of three parts with a reading for each part which would make a Series of three. See below.. PartNum Reading SeriesNumber SubSeriesNum RecordDate G1234 150.5 2212 1...