Search results for query: *

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...

Hi there, how can I use the getrows method in DAO to populate unbound textboxes in a 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...

hi, i am using ADODB to find records in a table that matches criteria in a textbox. It works fine except when I try to use it to find an ID field (primary key) Dim rsFname As New ADODB.Recordset rsFname.Open "SELECT * FROM tblCustomers " & _ "WHERE CustomerID = '" &...

Hi all, I have this problem regarding relinking mysql server access does not remember the connection and keeps on popping up asking for authentication CnnString = "ODBC;DRIVER=MySQL ODBC 5.3 ANSI Driver;DATABASE="db_production";OPTION=2048;PORT=3306;SERVER="...

Hi all, I have a linked table where I want to save images in SQL server. I am using MSaccess as front end. Any ideas how am I going to store, read BLOBS? I found this article https://support.microsoft.com/en-us/kb/103257 but am still clueless how am I going to implement it. Thanks in advance :)

Hi all, I have two forms, the mainform contains a listbox where all the records I entered will be displayed and the other form which I use to enter a new record. Whenever I post a new record the listbox on the mainform refreshes however it sticks only to the first record. How is it possible that...