Search results

Thank you for your explanations. I always used the logic you explained and never had a problem. I created the table relationship before I created the query. Is there any options I have to check or uncheck in "Access Options" section in 2007? Thanks LANA

Thank you all for your reply. The whole program is written in Access. Originally I wrote this program in Access 2003 which works fine without any problem. Today I installed it in two different computers, both having access2007. It works fine in one but does not in the other. I attached two...

Thanks for the reply. My tables are linked to the interface program. The program is written by Access. This works fine in one 2007 but not working in another. !!!

Hi there, Happy new year to all. I have an existing program which works fine in one laptop which has Access 2007. When I install this on another laptop with Access 2007 then this happens : in one of my query, the one-many relationship becomes a single line.!!! Any help would be appreciated...

thanks for the reply. please have a look at the attached file. cheers

Hi , In access 2016, grid lines are shown where there are no fields. But in 2003 this section is blank. Is there a way to make the datasheets look like 2003? Thanks

Yes I tried but again it gives the same error. Every form opens in design mode and the program works fine but I can not export the forms, modules.. / only queries are exported without any error.

Hi, Thanks GinaWhipp. I tried what you suggested but only a few forms were exported and the rest gives the same error.

Thank you all. My database is 7424 kB . This is only the program not the tables. Table are linked and the size is 1384 kB. I run the compact all the time (actually when I see the file is getting unusually big). Appreciate your help.

Hi Ridders, Thank you for your hep. I have done everything you mentioned, one by one. BUT still I can not import any form or module or report from the old database. The reason I want to do this is that one of my forms performs very slowly (but no errors) and I decided to make a new database...

I tried to zip the file but the size is more than 2MB and I can not attach here.

I tried what you suggested. All the queries are imported without any problem. BUT all the forms, modules , reports, micros give the same error as I mentioned before.

Thanks you so much for your time. First I am using access 2003. Second I don't understand ADD VBA Refrences??!

I don't remember the first time. Maybe not. But later I tried importing the tables first . still not working.

Hi there, I hope someone could help me! I have an access 2003 database with linked tables and lots of forms and queries. I tried to create a new database with importing the forms and the rest but only queries are imported without problem and for the rest I get the following errors : The...

Thank you all. Actually my own code works. I compacted the database then it worked?! Table in question is a temp one and the data in it is cleared all the time. Maybe something happens when data is deleted. Thanks a lot.

Hi there, I have a table which has 4 records. I use the followings to count the records: Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("tbl_calc") rst.MoveLast aaa = rst.RecordCount rst.MoveFirst this returns 44 instead of 4 !!!!! Any ideas? Thanks

Dear gregmiii, I came across a post by you which is the same problem I am having. Finding/highlighting a record in a sub-form. Have you manage that? If yes, would you share it with me if possible? Many thanks Lana

I think I solved my own question.!!!! I put two sub forms on the main form which is Books input data. One is for Author(s) and one is for category(ies). Record source of each sub form is a query built with two tables. In this manner both tables will be filled with proper data. Thanks

Thanks for the reply. My question is about Books_by_Author, first of all do we really need this? We can add a field to the Books tables by the name of Author.... Secondly, in order to complete this table " Books_by_Author" we need to have a form to enter the required field data? Right? As you...