Search results for query: *

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

thanks a lot :)

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

thanks a lot!

ok my point is I dont want to open the report I simply want to export it to pdf? Isnt it possible?

yes

...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 = db.OpenRecordset(wsSQL, dbOpenDynaset, dbSeeChanges) Reports!rpt!subject = rs.Fields("subject").Value...

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 :)

Muchas Gracias!

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

If that's the case I would prefer to use listbox instead. me.custname = me.lstbox.column(1) me.customernumber = me.lstbox.column(2) etc...

Please help me fix these. Thanks in advance.http://files.engineering.com/getfile.aspx?folder=0128c33f-555c-4e7c-a2d0-7236b223407d&file=customers.accdb