Recent content by profxavier27809

Hey there, Thanks first of all to all the people who spend their time solving problems on here. My question is, I have a text file with numbers like 6003860012346611. When I try to import this file into excel, it automatically either makes the number look like this 60038600+15 or if I copy...

Hey there, Is there a quick expression to put in the control source area of a field on a report that says COUNTIF([Sample Text Field] = "NO") I would like it to only count the occurrences of NO.

Is there any way you could zip the file and send it to me at profxavier278095@excite.com to let me take a look at it for you. It doesn't sound that complicated.

I would like to know if there is a way to use an LDB Viewer to record the computer name that logged into a certain access database in 2002 format. I do not want to create a separate form for them to log in but rather just record the computer name that logged in. There are several examples out...

You guys have no idea how awesome you are! I so appreciate the suggestions and proactive attitudes in here. I will try that, but I seriously need to learn select case I think.

I am not sure how i would apply that to select schedules. The values that show on the report are 1,2,3 etc...I don't have the B1, B2, B3, etc...directly connected with those numbers anywhere, so I need to in what the values for 1,2,3 should return. this would work if i was only looking for 1...

Hello there, Thanks for all the help you guys give first of all. I have a report that returns values 1,2,3,4,5...each of these values represents a schedule B1,B2,B3,B4,B5. In the OnOpen I was trying to write like 10 IF statements but don't know how to properly do a bunch. I was writing...

Ok I figured it out. Now I want it to say "Day" or Days". I tried this on the reports OnOpen If Me.Text7 > 1 Then Me.Text6 = "Day2" Else: Me.Text6 = "Day" End If End Sub It tells me "You entered an expression that has no value" Although it clearly has a value. Is there something I can do...

Thanks for that. I went and looked around at a few spots but all they were showing is how to enter like a date, and it returns the number of days you have left until your next birthday, until Christmas, etc...This one was the closest: Function DiffADate(theDate) DiffADate = "Days from today...

Hello all, Thanks first of all for all of the help I always receive in here. My question is I have to fields on a report simply reading from a query. They are Effective Date and Warning Delivered. These are formatted short date with an input mask of 07/12/05. I wondered if you knew of a...

Hello all, Thanks first of all for all of the help I always receive in here. My question is I have to fields on a report simply reading from a query. They are Effective Date and Warning Delivered. These are formatted short date with an input mask of 07/12/05. I wondered if you knew of a...