Search results

There appears to be a weird issue with the browseto command. If I use it in isolation, it works as expected. If the same browseto comes after any vba that includes the use of "set", then it gives a runtime error 6054. my browseto code is as below: DoCmd.BrowseTo ObjectType:=acBrowseToForm, _...

My code works fine, so I can connect to my sql server and access the tables stored there. My issue is this, if for whatever reason (no internet or firewall issue etc), the front end cant connect to the backend, then you get a horrible timeout message, and then next screen is even worse. It...

I hope everyone is safe and well. I currently use cdo to send emails within my front end. Works well, but some smtp servers / accounts require a tls secured connection I have experimented with config.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendtls").Value = True However...

Ok, so here is the situation. we have a mainform, then the navigationsubform. On the navigationsubform is a subform which has sourceobject of a report. This report is based on a query which references a textbox on the mainform. The issue is that the report is always empty unless you requery...

I have an access FE, SQL BE. Everything is working well, however as the system is getting bigger and busier we are now getting more and more write conflict issues. This is where a warning pops up saying there is a write conflict, do you want to save, copy or drop changes. This is obvious...

Hi guys, Im just trying to open a form in the navigationsubform space, just like a navigation button would do. I was hoping there would be a simple parameter like target=, but i cant seem to find any such thing. Any ideas? thanks,

Is there a way to have a control on a form which is like ms Paint? I am trying to see if it's possible to draw in a form, and save the image.

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

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

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

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

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

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

Hello, I think I have another database corruption problem. When I use the navigation buttons at the bottom to skip forward or backwards through the records on my form, it skips certain ones. I can see them in the backend and the information all appears there and intact, however it refuses to...

Hi Everyone, I have a simple report, one of the columns is a date. The report works fine, but if I right click the date and try to filter for example for today, it behaves in a weird way. It either comes up with a data miss match error in criteria expression, or just shows me some of the...

Hi all, I have been building an access database for our healthcare company for the past few months. I have learnt so much. However, we have had several corrupt database issues, and Im starting to think that access just isnt up to it. I am using a split database, with a batch file to load...

Hello, I have a button which opens a report in print preview mode. When it is clicked, some of the text boxes are empty. If I then open the report in report view, or layout view, the data appears. Anyone know how to make it appear first time in print preview mode?

Hello, So heres the problem. we have a form and a subform. Subform is in datasheet view. I want to be able to change a value on every record that appears in the datasheet filtered view. Eg. Im collecting all transactions for each individual. So I list the transactions by user ID. This is...

I want to display some average data on an input form. The average data is based on a query from the same table as the form. I can make the query, it generates the average, I can display this on my form, but now I can save the recordset, its giving the error the recordset is not updateable. Is...

Hello, Im trying to create a report, which will detail a history of a client. Some clients have purchasing history, some we just have their contact details. These are stored in separate tables. When I make a report that contains anything from a table that the client does not have an entry...