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...

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...

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...

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...

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 am trying to figure out a way to schedule date. I need to be able to have a begin date, end date, time, and check boxes to select the days of the meeting. I basically want to take a student, put them in a class, enter the begin date, end date, times, select the days of the week, and have it...

I have a table with two primary keys, SSN and EntryDate. From a form, I want a custom message box that tells the user that an applicant has already been entered, and not the long default message that access uses. I am using Access 2002 with the 2000 file format. I have tried a lot of stuff, but...

I have a report that has one subreport. On the subreport I have a text box that will count the records in that subreport. I have a control on my main form that pulls that number out of the subreport. This works fine until I have a subreport with nodata, and then my text box displays #Error. I...

I need help with code. I am just learning vb. I have a form named frmCustomers with a subform names subfrmTrans. In the main form I have a check box that I want to control the locking and unlocking of the subform. I can write code that will lock text boxes in the main form, but cannot figure...

I need to know how to open a file(same name and location everytime) word or excel with the click of a button on my form. I have limited VB and have tried eveything that I can think of. Any help will be greatly appreciated.

I have a subform that is based on a query that filters check boxes = no. I want a command button that will "refresh" the form and display any record that was not checked yes. I have tried many different things only to run into a brick wall. I know very little VB. All the tricks I try are...