Search results

Thanks guys, but I dont think I made myself clear. I have a login system, and it works fine, im using a dsnless connection to a sql back end. But the problem with access is that the login and password to the sql can be easily seen by just opening the front end in notepad etc. So someone can...

I have an access front end, and now a sql backend. The problem is, as many know, the uid and pwd are kept in plain text so can easily be "hacked". If the be was a split access db, the pwd for the BE is also stored in the same way :( The ODBC connection string doesnt appear to let me use...

thanks guys. I wish I could get back the 3 hours of headaches...

I am making a very simple diary. I have made a table, it has ID, Patient ID, AppointmentDate and SlotNumber. all im trying to do is have a text box that will fill with patient ID if the slotnumber and date is checked. This is what im using now : =DLookUp("[Patient...

Thanks Arnelgp. That edit fixed it. If your ever in the UK, let me know and I owe you a drink.

Im trying to delete a record from a table. Currently gives a runtime 3061 error, Too few parameters, 1 expected. Here is the offending code sql = "DELETE * FROM [Diary] WHERE [ID]= Dlookup([ID],[Diary],[AppointmentDate]='#[me].[Text13]#' and [SlotNumber]=2)" CurrentDb.Execute sql Im trying...

you need to do something like this if nz(your current null expression) then set your value to "0" rather then null else end if

you should really be thinking about using azure/ cloud sql. Easier for everyone. You can distribute a pre set up FE which connects to the database for that client in the cloud.

its fun, but you realise just how powerful and user friendly access is when you start messing around with sql/mysql.

Im trying to link a table to a access file. I can do it manually fine, but I am trying to do it with vba. I have used tabledef and tried to connect using odbc and oldeb but i get isam errors. sConnect = "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=Z:\Documents\PMS\Database_be.accdb;Jet...

As we know, Access doesnt seem to change much lol. Im going to answer my own question to help others: to get the listed values in each column, you can use code like this Me.Text5 = Me.List2.Column(0) & " " & Me.List2.Column(1)

thanks, that got it working for me. Next issue is how to I assign the selected values into text boxes? If i use list.value I just get the value from the first column, if I use the variables add1 add2 etc from the vba, they dont relate to the selected values in the list, just the first ones on...

Im just getting the postcodes for nw10.... No matter what I put in the search field.

Also before I did all this, I was weighing up the pros/cons. Now I have done it let me summarise. pros -definitely faster. It strangely seems even faster than when front and back are on same pc. My mysql is remote, eg on the internet. I have been testing on a 4g dongle, and its almost as fast...

One of the outstanding issues I have is that I cant seem to find a way of connecting to the mysql without having to install the odbc mysql driver on every pc. This is a real hassle for deployment, as you not only have to install it, but enter the mysql user name and password. You cant just be...

I thought I would share my access, to split to sql to mysql journey. I really enjoy developing in Access and VBA, and our database and company have grown to the point where we need many users in different locations accessing. Im experimenting with a mysql server for our expansion, and heres the...

the datasheet is organised by time, and I want to know a value from the most recent entry. eg each patient has many visits, but only one recall date. the subform shows all the visits, but I want to copy the most recent visit's recall onto the main form. does this make sense?

sorry to revive a dead thread again ! However I am trying to accomplish the same thing as sv89, however bobs answer appears to be deleted. Basically I have a form and subform, the subform is in a datasheet view. I would like a value from the top result in the datasheet to be copied into a text...

Apologies, your both correct, CDO is working fine. I googled and found some conflicting information, but I have implemented a working cdo emailer today, and its great :)

Hi everyone, I want to automatically send an email in the background from a form. Its a simple Customer service type email once a client has reached a certain point. I am aware of the CDO option, however I believe it has now been retired. I did not want to use outlook as not all FE users have...