Search results

Yes! That has fixed it...thank you so much! I would never had thought of that:D

Hello again guys! So im trying to execute a VBA code on my AutoExec macro. This is what ive done so far: 1.) Created a module with the following code: Option Compare Database Option Explicit Public Function import() As Boolean DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12...

yes! I noticed that afterwards too :)

Ha! I just managed to fix it! I realised that between "acimport, kunden" there should of been the spreadsheet type. So my working code looks like this now: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Kunden", "e:\pizza program\kunden.xlsx", True Thanks :)

Hello all you genius MS access users! I am trying to get this simple code to work, I just wanted to import my "Kunden" table from a XLSX excel file with the following code: DoCmd.TransferSpreadsheet acImport, Kunden, "e:\pizza program\kunden.xlsx", True But i seem to be getting this runtime...

This worked like a dream! Thank you so much! And everyone else too :)

I have found stuff like this: Dim strInput As String strInput = InputBox("Enter something:") If StrPtr(strInput) = 0 Then MsgBox "You pressed cancel!" End If That seems like what I need, but how do I apply it to my own code??

Hi all, so I have the following code which works fine when inputting the data etc: Private Sub Umschaltfläche13_Click() TempVars.Add "bestnr", InputBox("Bestellnummer Eingeben") DoCmd.OpenReport "druck_liefer", acViewReport DoCmd.PrintOut DoCmd.Close TempVars.RemoveAll End Sub The issue is...

I tried it with the database you posted up, I couldnt get the same error there either. No idea why to be honest.

Hey guys, thanks for all of your input but when I ran the database on the intended PC for testing purposes, I could cancel the input box without any dialogues popping up. Strange...but whatever lol :) Regards, Navi

So that pops up when I choose to cancel on the input window. I think its like an unexpected end to the script, right? If this doesnt help I'll upload the database

!WARNING! I am using Access in German so you will notice some strange words written in the code :) Hi Guys, So I have a button with the following vba code which runs when the button has been clicked on: Private Sub Umschaltfläche15_Click() TempVars.Add "bestnr", InputBox("Bestellnummer...

Hi guys, I actually solved this by accident by creating an aggregate query, which grouped the data and gave me the some totals as well so that worked out rather nicely :) Thanks for the responses

Hi Guys, So im trying to make a simple calculation in my order form which is in datasheet mode (if that makes any difference) So its very simple stuff, my goal is (qty * (item price + extra fee)) So "total preise" works fine, the code is: =[Preis]+[Extra Price] so for the next but, to...

Right ok, I followed this guide: http://www.opengatesw.net/ms-access-tutorials/Access-Articles/Microsoft-Access-Query2.htm#Grouping_Data_with_Aggregate_Queries_in_Acess Now in the example shown, it looks PERFECT for what I need. But... i followed the few simple steps yet it doesnt seem to be...

Ahh ok, I did see that mentioned somewhere when I was researching for a solution...ill look into it and give you an update :)

All the fields are in the screenshot I posted up. So basically I want the first 3 lines to be grouped and it should show like this: Bestellnummer Telefonummer Addresse Ort ..etc.... Total Preis 10 545566 Per London...

I need this part for the screen so it will be a form. I just need to refine the data being shown by the query.

Hi, I am currently designing an ordering system with a many to many relationship. I have gotten the foundation to work, to take orders, but since an order can compose of several different items or same items but each one modified I have a junction table which records every single item ordered...

So I have managed to get around my issue, I have seperated the form, so now the subform appears in a seperate form. I then set the default value in the field on the second form as "=[Formulare]![Bestellung]![Bestellnummer]" which works nicely as the first form is still open in the background :)