Recent content by edp1959

Can someone help with code to split this text field in my table into multiple columns? I want to do this in my database without having to export to Excel. The word seperator would be a space. Thanks

I have a FE database that on initial setup the user will enter the drive letter of the mapped location where the BE resides. The FE will then update all the linked tables to that path. This should work but for some reason the FE locks up (stops responding) when I test this. Any suggestions as...

Sub yourname() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim dbs As DAO.database Dim rst As DAO.recordset I got this code from a previous post here to be used for transfering data to a cell range in excel. I get a "run-time error 430" Class does not support automation or...

I would like to create a couple of data entry areas on my form. Each area would have a maximum entry of 30 characters including spaces. I would like to have each character enclosed in its own box. Is there a way of doing this other than creating 30 seperate text boxes for each character and...

How should this look if placed in a module to be called in several places of my database. Just putting it in as is gives me a compile error. I have defined MyF and Set it depending on which form is running the code, so that is not the problem. Nz(MyF.T1, " ") & Nz(MyF.T2, " ") & Nz(MyF.T3...

Is this possible? I have a SQL statement stored in a module that I would like to call as a record source for several forms. I tried this but it didn't work. In the OnOpen event of the form I put the following code: Call PCSub_RS2 'Name of Public Function where SQL statement is...

Thanks, this worked fine. I wonder why my previous code worked on other forms in the same database.

Help - This should be simple I'm using this code to clear unbound text boxes on my form. I keep getting an error message "Object doesn't support this property or method". I'm using this same code on other forms and it works fine. What am I missing? I'm using Access 2000. Dim ctl As Control...

Never mind I figured it out.

I have a universal dialog box with a command button that closes the dialog box when clicked. This dialog box is used with several different "master" forms. I would also like to go to a control on the "master" form when the dialog box is closed. Is there a way to assign code to the command...

Works great! Thanks for the help. This forum is the best!

SQL - what's wrong here I have a field (Count) on my form (NN_ON) that displays the number of records returned by the SQL below. The parameter for the SQL comes from a field on my form (NN_ON) called (srID). I get a runtime error 3061 "To few parameters expected 1", if the WHERE clause is...

Look at your quotation marks and you shouldn't have brackets around "MCR Table". Your code should look like this and it will work. If Not IsNull(DLookup("[REA Number]", "MCR Table", "[REA Number] = '" & [Forms]![MCR_Input _Form]![REA Number] & "'")) Then Msgbox "Already Exists" End If

change property value of field I must have been brain dead when I sent my last reply. After I sent it I realized what you ment. Thanks for the help, this worked great.

I'm new at this so bare with me: If ctrl.tag = "A" then How would the "A" relate to my text fields that I want to change?