Recent content by matt020876

Oh i have the traditional setup of 2 access databases - Front-end and Back-end There is a function that creates a new tables in the backend. What i want to do is for the front end to check all the tables that exist in the backend and if they are not linked (i.e new table created) to the...

Any idea how you this word work with assigning sql commands to a variable? i.e Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Set db = CurrentDb() Set qdf = db.createQueryDefs("") sql = "SELECT qryClaims.currenc, Sum(qryClaims.[Total Invoice...

mmmm i have done it before but cant for the life of me remember how

Im just writing to enquire, if using the FILEOPEN api - i can customise the titles of the open and cancel buttons?

Ok i made a mistake a meant a bound ole control not an image control - thanx for your preply

I need some vba code to insert an image file into in image control on a form - ive managed to get the file dialoge box to open and to store the selcted results but cant get the mage to insert into the control on the form. please help!

Trying to do something similar but we will be sending something out on a CD - anyway to detect the SMTP settings?

Ok ive got the code to convert the data in a form into an excel spreadsheet and send it as an email. The problem is that this database is going to be used by our customers. Is there anyway i can cater for different email systems - i.e detect what system they are using? Thanks

Im developing an access runitme db for cusytomer to fill in orders. I want to put a button it so it automatical;lt sends an email with this info. The trouble is kowing what mail system the client uses - is there anyway i can detect this? Thanks

Ive managed to setup an ODBC link to an AS400 library. (Client access is installed) The problem is even if i set the username and password in the DNS im still promted for a As400 sign in when i first access the table. Ive even got the 'bypass sign in' selected in the options - can u help - its...