Search results

Hi all! Im back with another question! Heres the basic outline: I have created a booking application in Access and on my switchboard I have a subform which is based on a query which lists all my current bookings and has the following fields: Booking Nr, Customer ID, Name, Apartment etc...

Hi guys, I need a VBA which would check if one of the fields is empty before proceeding with the rest of the code. Ive tried using something like: if [telefonnummer] = "" then etc etc but no luck. Ive tried setting validation rules on the form itself too, no luck. They dont seem to actually...

Hello All! I have created a database which is mean to export data to excel, this all works fine on my system where I have office installed fully. But on the clients PC, he does not have Office, I installed Access runtime in order for the database to operate but it seems like the database doesnt...

Hi all, Is there any way of recovering deleted records from a table? And what if the database has been compacted and repaired? My client wants to have a lot of privacy with his database so I just wanted to verify this. Thanks! :)

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

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

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

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

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

Hi, Im creating a database for a pizza business in Germany so please excuse the german Field names lol. So ive started it, created my many to many relationships and also created a Form with 2 subforms, one to display the customer info and one to actually take the order (datasheet view) I can...

Hi guys, I have made a booking system in access which works brilliantly. There is a feature I would like to include and I thought I would ask you guys, as last time you was able to help as well. Essentially I want a query which will ask me to input the required dates of the booking and I want...

Hello All, Ive made a booking system using access and I wanted to create a cleaning schedule. Essentially I want this query to look at the date of the arrival and then allocate that client to either Cleaning Schedule 1 or Cleaning schedule 2. Clients arriving during 1st - 7th or 15th-22nd will...

Hello all, I am currently in the middle of creating a database as a means of keeping records of vouchers codes. The idea is....when someone uses a voucher, I will then be able to input the name of the customer with the voucher code in the form. This is meant to do two processes: 1. Keep a...