Recent content by LynnEsther

Did you keep the front end in Access?

Thank you for the suggestion to create a new db and import the objects. That's what I did and all is well. :D

Help! Suddenly and without warning, my Access 2000 database will not compact. When I go to compact/repair nothing happens. Does anyone out there know what may have caused this and what I can do to fix it? My database is growing by the hour and desperately needs to be compacted. :eek...

No, the database is not split. Everything resides in one massive file. I will try splitting first and see if that resolves things.

Hello. I recently inherited a very sick MS Access 2000 database that crashes several times per day. It is ~60 MB in size and has about 30 users in there reading/writing at any given time. We are considering upsizing to SQLServer and keeping the Access front end (linking to the SQLServer...

I am at a loss. I have a very simple query with the following criteria: Field1 <> "ABC". Problem is, in addition to returning records where Field1 <> ABC, it is also returning records where Field1 is not null. I don't understand why my query would exclude records that I'm not explicitly...

Hello. I'm brand new to Excel programming (I'm an Access person) and am trying to make something work but am having trouble. I have a user form with a combo box. I would like to be able to filter records on the data tab based on the user's selection from the combo box. I'd be very grateful...

Thanks, but I don't think that's it. I am actually importing, not exporting. I am setting up an ODBC connection in Excel to my Access database. I then select the particular query, bring in all the fields, and when I click 'OK', I get the message. Boggles the mind.

Hello. I have a very simple select query in Access that I need to import into Excel (so that it can be refreshed from within Excel). During the import, I get the following error message in Excel (although I have seen the same error in Access on other occassions): 'Two Few Parameters...

I am struggling with an IIF statement and am wondering if anyone can help. I have four date fields: Received_Date, Install_Date, Inventory_Date, Last_Logon_Date. I am writing a query and need to create a fifth field called Latest_Date, which will take the most recent of the four dates listed...

I am having some issues with MS Access that I hope someone can help with. I have a report that has some lines/borders in it and when I export the report to MS Word via Access (creates an rtf file) - the lines/borders are not showing. I can create the file to pdf and the lines/borders show up...

Sadly, that won't work. Many of the good records (not duplicate Serial_Number) have null Field3. :(

I have a query where say: Select Distinct Serial_Number, Field1, Field2, Field3, etc from TableName. In some cases there are two records with the same Serial_Number, but in one record all other data is blank, and in the other record, Field3 has data. I need to run a query that shows me all...

Oh, I was afraid of that. FWIW, the default vaule is indeed set in the table. Any other ideas? Another thing, I have other fields on this same form that are set as currency. Those display the default value just fine.

I have a numeric field where I set the field value on my form to zero. However when I run the form in form view, the zero does not display. What am I missing? Thanks in advance!