Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: humpydumpy2000
  • Order by date
  1. humpydumpy2000

    Linked tables appear #deleted

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

    Linked tables appear #deleted

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

    Getwrows method

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

    Getwrows method

    Hi there, how can I use the getrows method in DAO to populate unbound textboxes in a report?
  5. humpydumpy2000

    Migrating to vb.net

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

    Make control visible

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

    Insert BLOB in SQL server

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

    save report as pdf

    thanks a lot!
  9. humpydumpy2000

    save report as pdf

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

    save report as pdf

    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 =...
  11. humpydumpy2000

    Create user, permissions

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

    Parse column values

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

    PRINT WITHOUT OPENING A REPORT

    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 :)
  14. humpydumpy2000

    VBA Check if table exists

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

    ADODB FIND RECORD

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

    ADODB FIND RECORD

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

    ADODB FIND RECORD

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

Part and Inventory Search

Back
Top