I have an accounting software which I bought many years ago, developed under Access 2003. It comes with Access runtime.
It works fine on a computer which has no access or access 2003.
Now I tried to install it on a computer with win 10 and access 2016.
When I run the program, it...
I have an annoying problem and hope someone could help me.
I created a function which deletes a query and then creates a new one with CreateQueryDef.
When I use this function from the immediate window, it works perfectly with no error. But when I call this function from a field in a...
I have used Windows API functions in access 2016 on Windows 10. I used the correct format for 64bit.
It works fine in one computer but gives me "Type mismatch error" on another computer with Windows 10 and also Access 2016?
Any help would be appreciated.
Thanks a lot.
I would appreciate if someone could help me with this problem.
I have a sub-form on a form. In this sub form data must be entered.
I need to execute a code when each record is entered in the sub-form.
I wrote the code in the "After_Update" procedure of this sub-form.
I am having a strange problem with TabIndex in one of my subforms.
It does not change. I change the numbers but nothing happens and the columns order does not change. (Access 2003)
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...
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 :
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")
aaa = rst.RecordCount
this returns 44 instead of 4 !!!!!
A data model is suggested for a library and book application (attached file).
I got this from the site introduced here in this forum (Industry Data Model).
My question is about the tables named : Books_by_Author and Books_by_Category.
Books_by_Author is connected to tables Books...
Is there a way to use a variable instead of a form name?
e.g. FRM1 is a form
Instead of FRM1 , a variable is used which can be any other form name.??????
In access 2003 if we make .MDE file, when it is run we see only our project window with its menu tab or tools bar.
I need to do this in 2007 and above. I tried but with no success.
Maybe this is very simple but I need your help.
As you definitely know and use Access "Find" window, which finds any data you need in any field the focus is....
Did anybody write a code to do the same thing??
I really appreciate any help in this.
I wrote a program in Access 2003 and it works perfectly on my computer but when I run it in another one , there is a problem.
The problem is : on a form Ioad I calculate a value and I declared it as public. I need to use this value in my form but it does not recognize it. As if...
I developed an access2003 program and I made .mde file from it.
It works fine and no one can access the tables.
BUT when the user creates a new DB in Access and imports from my file then he can have all the tables.
Is there any way I can prevent this?
Can anybody help me on this one?
I want to design a form to do the search job as the access "Find" form.
For example, in a form 5 fields are displayed. I want to search in a field which the cursor is in there. I need another form which I can type the search string and finds...
I am new on this so bear with me.
I have a table which has two fields one is person's name and the other is a code.
Now when I use a combo box to show the "name" field but the bound column is set to the "code" then the...