Search results

Thanks, the find duplicate wizard only gives me an option to search one table for dups. I want to bounce table2 against table1 and obtain the results. Should I merge both text fields into one table? Thanks. Fen

Hi, I have two text files each containing data. I want to import the text file data into seperate tables say, data1 and data2 then bounce them for dups. At the end a simple report that shows the matches found. Has anyone seen such a db already working? An example would be much...

Thanks, What I am trying to do is when a user enters a number say 100 in a textbox, to have that number multiply by say .585 and show the result in another textbox or on a label so they can quicky calculate their mileage. It works fine with a button howeve where i want to place the code is...

Is is possible to take a number placed in a textbox, multiply it by a number and show the result in another textbox or on a label without using a button? I am using Visual Studio 2008, coding in VB. Thanks! Fen How

Hi, I am running the following code to exit my database. DoCmd.Quit When I run this I keep getting a Runtime error 2501 "The Run Macro Action was cancelled" I have no idea? When I try to debug it rips through all of my code and errors out. Can anyone help? Fen How

Hi, I am using the following code to export the results of a query to a MS Excel Workbook. The problem is it is exporting in a format other than 2003. Can someone tell me why and how I can get it to save the workbook as an Office 2003 document? Thanks. Fen How Function ExportExceltoQB() Dim...

Hi, Is there a way to create a macro that runs a query, exports the data into an excel spreadsheet into a specific folder with a fixed name but with the date and time the report was created automatically? Thanks. Fen How

Hi, I am working on a form, everytime I add an Option Group with the value to store the selection to a table and save the form Access Crashes. If I create a new form I can create the option group no problem and save it. Can someone tell me why this might be happening? Thanks. Fen How

thanks, it will not let me do it as it says it violates integrity rules, the DB is a one to many with the PK in Main table autonumber. Thanks. Fen

No, should i do that? How do i do that? Thanks

Hi, I have two tables joined by PK. The form has Main and Sub. One Main can have many Subs. I am trying to create a macro or Query that will delete a record the problem I am having is if i delete a record from table 1 (Main) the data in the table 2 (Sub) stays in the DB. Can anyone tell me...

Hi, I know this forum is for access stuff but I am trying to find a person with a Flash Skillset to do a template mod for me. If anyone knows of someone can you please post? Forgive me if this was out of line. Thanks. Fen How

Thanks, The problem is this, I have about 30 databases out there that need to be updated, the end user is not equipped (skillset) to add the new columns in their databases. Typically I send out a new database, they run the mod, the old tables are added to the new database and away they go. Is...

Hi, I am using the following code to import data from an existing database into a new database as new releases have been distributed. 'Add new tables to Back End DoCmd.RunSQL "DROP TABLE tblMain;" DoCmd.TransferDatabase acImport, "Microsoft Access", dbPath, acTable, "tblMain", "tblMain"...

On another note, Is is possible to add the text that goes into the txtbox also to another txtbox that has other information in it? For example, I have a description area that holds information but the data starts out with the status, it would be awesome if I could change the lead on the...

That was it! Thanks a million.. Fen

Hi, I have a txtbox on a form that gets an updated value from a selection on an option group on the same form. In the afterupdate event of my option group I am using the following code: Private Sub Curative_Status_Option_AfterUpdate() Select Case Me.Status Case 1 Me.Text135 = "Not Satisfied"...

This works but. The macro runs every second... I do not want to quit the DB so how can I only have the Macro run once.. Thanks. Private Sub Form_Load() ' 1000 being every 1 second, the timer will run. Form.TimerInterval = 1000 Me.Visible = False End Sub ' ' Add 2 fields to the...

Thanks everyone how abou this? I found this code lastnight but cannot seem to get it to work can one of you clear it up for me? Thanks.. * Create a form, add a timer event to the form. * Autoexec macro (on open DB macro). Add the following commands: - Open the timer form. - Hide the Timer...

Help Understanding this one.... Hi, can someone help me with this? It appears that it will do what I need but I cannot make complete sense of the instructions? Do I create unbound text boxes on my form or lables? Thanks. Fen How