Search results

Got the following error : "cannot map to a read-only property". I don't understand this error. :( This is the code which I use: Private Sub Form_Load() Dim sqlBron As String Dim sqlTransform As String sqlBron = "SELECT tblPatientenLijst.PTN_ID, tblPatientenLijst.PTN_Naam...

It is possible to make a link between child and master through VBA, like this .RecordSource = sqlOffertesWijzigenBasis .subfrmOfferteProductenWijzigen.Form.RecordSource = sqlProductOffertesWijzigen .subfrmOfferteProductenWijzigen.LinkChildFields = "OFID"...

I have a form with one subform. Through the button "Delete" I can delete the records in the subform and the record in the form (referential integrity enforced). However after the deletion of the records my form is empty. The command "Me.Requery" doesn't do anything (see picture). How can I...

I hide the navigation pane when starting my application but after this code it appears again? Strange? CurrentDb.Execute "SELECT * INTO [;DATABASE=" & txtDatabaseFilePadNaam & ";].tblOVSGToetsresultaten " & _ "FROM [Excel 12.0;HDR=Yes;DATABASE=" & txtBestandPuntenBestaat & ";].[Pagina1$];"...

An Excel is created and sent for each teacher. The number of columns in the Excel is variable. This works for the first record, but for the second record I get the error message 1004: Method Range of object _Global failed. The last thing I have done now is the Range "rng" set to .clear because I...

When I try to open a workbook in my Excel application I get the error 1004 ("the file .....xlsx can't be opened because the file extension or the file format isn't correct"). I have checked this and the extension as the format is correct. I got the error on the line ".Workbooks.Open...

In one of my application doesn't work this statement. In the other I have no problem at all. It gives the error "Sub or function not defined". :mad: LocationNewApplication = DLookup("VersionNewAppLocation", "tblVersieProgramma") & "\" & CurrentProject.Name Set db =...

Starting with a click on a button to open a report gives error 2046 (Run-time error 2046 the command or action 'OutputTo' isn't available now). When I put a button (_Click) on a separate form called by the previous form, my report opens without any problem. When I put the command lines in the...

I have a procedure to make a query but in runtime I get error 3078 ("The Microsoft Access database engine cannot find the input table or query 'name'. Make sure it exists and that its name is spelled correctly."). The query isn't displayed left in the list of the queries (list of all the...

I have a batch file that I call via VBA shell command. This batch file refers to a folder on the server. One character of the folder name contains a character with an umlaut. This doesn't work for a batch file called through Access! In addition, the folder name is called via a variable. Can this...

In Access 2010 (Win 2008) it is possible to put my own icon for my application on the taskbar. When starting my app my icon appears on the taskbar. Now I have win 10 en Access 2016 and my icon doesn't appear anymore on the taskbar. I didn't change anything of my app. What do I have to do in...

Strange thing: but get something like attachement when I try to print (preview) some (not all) reports; :confused:

I first want to copy a table and then to amend it. This is the code. DoCmd.CopyObject , "tblLijstProducten_Kopie_" & Now(), acTable, "tblLijstProducten" sqlUpdate = "UPDATE tblLijstProducten SET tblLijstProducten.ProductActief = False;" DoCmd.RunSQL sqlUpdate...

Hello, I am an experienced Access programmer for the government of Antwerp, Belgium. Hope to get a lot of answers to my sometimes to others - simples - questions. Greets