Search results

Thanks for the tips, Pat.

Hi Pat: Thanks. This means I have to modify my form to allow a search before any record is displayed. I'm not sure if I saw this in Access before but is it possible to display the form without any record being displayed until a search is made by the user? Second question: will those forms...

I have a form that needs to have an SQL table as its recordsource. Is there a better way to connect the form to the table without using ODBC? I have tried the ODBC approach but it seems that the form's data manipulation response time is too slow. Or it is just wishful thinking on my part to...

Thanks but I already did a long take by cloning the subform's table and adding up the individual lines. Then I simply updated the main form's text box from the aggregate variable. It seemed to work.

Hi Pat: Sorry if I didn't explain quite clearly my problem and you seemed to have missed it. The update query has a table which is the one updated and an aggregate query linked to the table from which the new value for the table being updated comes. I was not updating the aggregate query. I...

I have a parent table with an amount column that stores the total amount of one or more child records' amount column. I created an aggregate query to total the amount on the child table per record in the parent. Then I created an update query to set the parent table's amount to the agregate...

I have a form/subform data entry screen for a loan monitoring system. Each employee record in the main form can have one or more loan records in the subform. I have a bound textbox in the main form that shows the total amount of the line items on the subform but bound to the main forms data...

Thanks, Pat. I haven't tried the previous suggestion as yet but I already had a workaround to the original problem and it was like what you said.

Thanks for the suggestion. I will try this today.

I need to edit a text file by reading it line by line and replacing certain strings with "". How do I setup the i/o section of my code? Pls. help.

My previous experience with working with Excel from Access always got me into running the whole code totally from Access. I created the code at Excel through macro recording and then I copy the codes to Access and run them from there after some modifications because the object references do not...

why not link the foxpro table to your access database and then create a query that appends new/selected records as per criteria you can specify either hard coded or parametrized. this way, you don't have to worry about the foxpro table version.

hi cpod: you're a godsend! i installed the jet SP6 on the user pc and the problem was solved. i have one happy user and thanks to you. more power.

i have a mdb using an attached dbf table. for some strange reason, the dbf table is read only when opened in my user's pc using winme and access xp but is editable when opened in my win2k access xp laptop. this behavior is consistent even when the mdb and the dbf files are copied on the user's...

Hi: I tried your code and I got the correct count. Just wondering what's wrong with the original code using ADO instead of DAO in your code. Anyway, yours is a good alternative if ever there is no solution using the ADO way. Thanks.

Can anybody please tell me why the RecordCount property returns a -1 in th last line of this code? There are two records in the 'CA' table and I'm using Access 2002. strCnn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & CurrentDb.Name Set cnn1 = New ADODB.Connection...