Recent content by rbtm2006

that does work partially... just cant figure out how to only keep the date and not the "DOB"

We import data from an external program into this DB. The external program does not have a place for DOB, so we use the email field. The problem is, on certain records, we use the email field for the email (go figure right...) I do not need any email addresses in the DB. Only the DOB My...

I have a database that is used every day. I want a query that will list which days are not in the database. We have to delete the raw data and re-import the corrected / verified data. We do make mistakes, so I want a query that will help us ensure all dates are present. Example. 1/1/12...

I simply use BulletPrinter. This works for us amazingly well... try it out

PERFECT. I dont know why I was having such a hard time with this one. I figured it our with your suggestion... Thanks pbaldy.

I need some help. I created an append query in which data from the web is downloaded and is appended into an existing table. Easy enough. Here is my delima. My PO Number is set up to use our fleet number of the van and the date of order. Example 18081512 would reflect van 15 and the order...

I did in fact try this at length... the problem is that I can not figure out a way for the function to erase all the info between the ().

I have several records that have "(stringofinfo)" at the end of the first name. So example: Smith, John (stringofinfo). I need to figure out a way to remove the "(stringofinfo)" so it just reads Smith, John. I really need to use a query to do this as I would really like to do this during the...

This is the code that I am trying in the Detail Section. When I try to run the report, it errors out and says that "Method or data member not found" on the Me.Full_name.Top part of the code... any help Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim lngTopMargin As...

Here is the DB with dummy data... Ill keep trying... I just don't understand the concept it is trying to have me do. OYY! Thanks for the support!

I am so totally lost with this... I have been trying and not getting anywhere... Let me post the DB so you can look at it thus far! I am sorry im not gettnig anywhere with it... I am trying but frustrated!! Thanks

Ill keep trying it.... dont know how much good ill be... but will try. thanks!

Can you explain a bit more...Is the value that will determine weather the box is checked or not a specific field or a result of a query of data?

That works perfectly to organize the trips to the nearest 30 min... thanks... what are you thinking for the next step?

The raw data we get from our provider has date and time in it. I have build a query that extracts the date and time in two separate fields. The date in the [TripDate] field (date/time) and the time in the [PUTime] field (date/time). Time Field 2:26:00 PM Date field: 1/18/2012