hi, thanks for your reply, as I've checked the tables in the server side has valid PK and unique keys. I think the problem lies with Microsoft Visual C++ runtime I can't figure which among the many I uninstalled was the main culprit.
Good day, I have a strange problem linking mariadb to msaccess. I had been relinking tables dsn-less and it works perfectly with mysql connector 5.3 until today when I tried to modify the code and make it 8.0 because 5.3 is too old (dates back 2014). Unfortunately, things went crazy. I am still...
I have two sets of data that needs to be displayed on a report, the first one will work nicely using a bound report however the other set of data needs to be displayed on the right corner first and last page of the report...
Hi all,
I had been using MS Access for many years and I fully understand it is very good for prototyping projects. I had been contemplating to move to vb.net since its the closest thing to vba. However I am skeptical given that vb.net is completely different thing I wonder if things would work...
Hi all,
How can I make a control visible in a report if it is in
Page 1
else
it wont show at all.
Tried this code onload using this but the control shows in next page.
if(me.page = 1)then
me.ctrlName.visible = true
else
me.ctrlname.visible = false
end if
any thoughts?
thanks in advance :)
Hola a todos,
I have this function working smoothly in MySQL database however I am puzzled why it does not work in SQL Server. Any thoughts?
Thanks in advance!
Dim objStream As Object 'ADODB.Stream
Dim objCmd As Object 'ADODB.Command
Dim varFileBinary
'Empty any matching...
hi all,
I would like to save an unbound report as pdf, the problem is access is bit confused what I did was to make a command button in a form and embeded the following code in an onClick event:
Dim wsSQL As String
wsSQL = "SELECT * from tblsubject;"
Set db = CurrentDb
Set rs =...
Hi all,
How am I going to create a user that would allowed only to create, delete and view their own databases but not the main administrator database?
Thanks a lot.
Hola a todos,
Does anyone knows hows to parse column values like this way:
I have some table where values are:
ID Category Name
1 A Apple
2 A Orange
3 A Mango
4 B Peanut
5 B Cashew
6 C...
hi all, is there a way to print a report without opening it or having a report preview? Once i click the command button it automatically prints the document minus the print dialog.
Thanks in advance :)
Hi, I do have a temporary table that is automatically deleted on application exit. However there are instances where I have to kill the app of course the temporary table will not be deleted. I can error trap when table exists to replace or delete temporary table however my problem is how to...
What I would like to solve to load record from a table to an unbound form. Using the code I posted at the beginning of this thread I was able to search related records loaded into form using customer number as reference. However loading related records using primary key is rather difficult...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.