Hi there,
I have a form with a subform. The recordsource of the subform is a table.
When the user changes the sort order of one of the fields in the subform, this sort order stays until the form is closed.
I need to change this sort order by VBA.
Any ideas?
Thanks a lot
Hi there,
I need to trap the date field entry errors on my forms.
The date format is mm/dd/yyyy
If it is entered as 08/20/2021, everything is OK, but if it is changed to 13/20/2021, I could not trap the error because the field value is still the old one (08/20/21).
I need to trap the error and...
Hi there,
Can anyone help me regarding the multi-value field?
I have a multi-value field and the selection is OK. Now I need to show the data stored in that field in a text box or a sub-form.
Example: stored data is "David,Smith,Lara" I can see it in the table or in a query but I can not use...
Hello there,
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...
Hi there,
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...
Hello there,
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.
Hi there,
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.
BUT ----...
Hi there,
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)
Any idea?
Cheers
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...
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
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...
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 All,
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...
Dear All,
Is there a way to use a variable instead of a form name?
e.g. FRM1 is a form
Forms![FRM1]!textbox1.SetFocus
Instead of FRM1 , a variable is used which can be any other form name.??????
Cheers
Dear All,
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.
Thanks.
LANA
Dear All,
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.
Cheers,
LANA
Dear All,
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...
Hi there,
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?
Cheers