Search results

Thank you. I will give that a try. Robert

I have a table with about 300,000 records. About ten fairly small fields per record. I am trying to change the length of a text field from 25 to 40 characters, and I get the error message, 'MS Access can't change the data type. There isn't enough disk space or memory'. I have never seen...

Gizmo: Are .fsetup and .caption commented out? Robert

OK thank you. What does that do? Robert

I have a form for which the Record Source is a certain table. Then on that form there is a button to display another form, which adds a new record to the same table. Then the new form is closed. The trouble is, the original form cannot search for the new record, until you close the form and...

I am struggling with the criteria for the DLookup function. What I need is the criteria to equal [PARTNUMBER] in the query I am accessing with Dlookup, with [MYPARTNUMBER] which is a field in a table being used in the query where I am writing the DLookup. So something like "[PARTNUMBER] =...

I see that the output option for Excel is AcFormatXLS. But if I enter that I get the error message "There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access". There are 17,473 lines in the table. That doesn't seem too much. The odd thing...

OK, I have that working, thank you. I see that I have to specify an output format. How do I specify Excel 97? I don't get a drop down list of options. Robert

I use SendObject to send automatic emails from my application. Can I attach a table or an MDB file to the email? How do I do that? Or do I attach a table and it sends it as a text file? Robert

I have a form with a subform. The subform is used to report a sales total, for today and for the month. When there are no sales today (a null result in one of the fields) the entire subform goes blank. How can I make it report a zero in the field instead of blanking the entire subform? Robert

I have a report with several subreports. I need to total the subreports onto the main report. How do I refer to the control on the subreport? I know that with a form / subform I would use: Me!Subform1.Form!Controlname But simply replacing 'Form' with 'Report' doesn't seem to work. Robert

I have a line of code in an old program: Dim CN as ADODB Connection This is giving me the error 'User defined type not defined'. I know I have to set something in a list somewhere but have forgotten how to do that. Can someone tell me where to go, and what to set? Thanks! Robert

I have a query that returns several records, typically 1 to 5. I need to print a label for each record returned by the query. Printing a label is no problem, but how do I print sequentally for each record in the query? Robert

Yes, this is for a business, with about 30 users. I am not involved with the servers though, I am strictly an application programmer. Moving from accdb to SQL seems like a very big task to me. Robert

Does anyone have a basic list of what I need to do to upgrade from accdb to SQL? For instance, do I buy SQL for the server first? Then is there an automated upgrade? What are the steps? Robert

I have a large application presently (spilt database) in Access 2010 and accdb. We are considering moving to SQL. - Are there any programming changes needed for SQL? - How would I create a test back end in SQL? Do I simply use the SQL command in Access, or do I need hosting, or anything? Robert

Access 2010. Split database. accdb database. Robert

David: The problem started as soon as we moved from Access 2003 to 2010. Now we have memory problems when users have two or three forms open, some with many queries driving subforms. It's a real problem, as users like to keep forms open and switch between them. They can no longer do that...

David: Yes, the database is split. I don't understand your question as to what is the back end? Robert

I have a serious problem with a big application. When the users have two or more big forms open, they get a 'System Resource Exceeded' error. This is in Access 2010. However, we used to do this all the time in Access 2003 and never got an error. Does Access 2010 use memory differently? What...