Search results

I am tired of trying to figure this out, so I humbly ask for assistance. This may be so simple. I have a procedure that will append a record with New, Edit, or Delete depending on the event. I have the BeforeUpdate event (if me.newrecord "New" Else "Edit") working great, and the Delete event for...

Life Saver Thanks a million!!! I was ready to pull my hair out. I knew that it was something in my data type, but could not figure it out. I tried cdate and everything I could think of, but I never used DateSerial and poof it worked. I knew it was something simple. Thank you very much!!! Wes

Why does this not work for me?:confused: I get r-t error '13': Type Mismatch *** datDate is from a DAO.Recordset rs!LastUpdate *** NewDate = Month(Date) & "/" & Day(datDate) & "/" & Year(Date) But this works.:mad: NewDate = Month(datDate) & "/" & Day(datDate) & "/" & Year(Date) Thanks...

Thanks for looking, but I created a place field, and used some vba and sql to renumber the fields for me.

Here is a jpeg of what I want. Thanks, for looking at it.

Plain and simple: Is there a way to have an unbound text box, in a continuos form, that will show the record number of each record in that form. The record at the top of the form will be 1, the next record will be 2, and so on down the form. I also need this to renumber incase I add a record...

Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I have all of this figured out, but what is getting me is the finish place (1st, 2nd, etc.) Is...

Never mind, I finally got my SQL statements right and the Loop that I need. As always, thanks for your help.

Here is what I am trying to do. I have a table called tblMailingList. It is made up of records from two tables. I can do that. Where I have a problem is, I have some customers the get multiple issues of a magazine. So this one customer's mailing address needs to be entered into tblMailingList...

I know when you see these you will think, "What are you doing?" So, I will tell you. I have to append certain records to another table multiple times. I have a field that stores the number of times the record needs to be appended. I thought that I could do it with SQL and a loop, but I can not...

I need to know how to combine two records. What I have is a text file that is imported into a table. The problem is, the text file has 4 fields on one line then 3 fields on the next line. Is there a way to combine these two lines into one record? I do not want to do this in the text file. I want...

Is there a way to cancel a form's close event? If a user clicks the form's close button, I want a msgbox to ask if they are sure, and if yes continue and close, else cancel the forms close event. I know how to perform the msgbox and the if statement. I can not figure out how to cancel the form's...

I recently created a database with an FE and BE, and I want to be able to back up the BE from the FE. In the FE, I added a menu item "Back up database...", and it works good for the FE, but I want it to back up the BE, where the data is located. The reason that I like the menu item is that it...

Thanks for the reply. I have never done a dbsnapshot. Any hints on what to do.

I have your standard customer, order, and order details database. In tblOrders, I have the the shipping address information. The reason it is in orders, a few clients can ship to different addresses and we need to track all orders and the shipping info. Here is what the boss wants. When a new...

When using the docmd.transfertext delimited, how do you make it delimited with a space? Also, is there a way to format the number fields to a #.00 format before doing this?

I understand the issues with size, but this what the client wants. What you have done is perfect, I just need the other information in the attendance table. If I try to explain the maddness, it may drive you insane. Like I said your stuff is perfect, I also need the other info. Please don't try...

RichO, this is exactly what I am looking for, but I need it to append to tblAttend. I got it to do that, but I can only get it to append the dates. I need it to append the SSN, cboActivity, txtBTime, and txtETime information. I have worked to try to get it to do that, but I am really new to SQL...

I guess the format is wrong. Date should be short date and Time should be short time. The unbound controls at the top are just holders for the user to type in the Activity, BDate, EDate, select the Days, BTime, and ETime. Then the user should be able to click the generate button and based on...

I have been off all weekend. I will try the code you posted, but I also threw together an example. I too am green to vba, I have code that will work, but it is huge. I know there is an easier way. I dont know all the date functions, and what they can do.