Search results for query: *

I have a table called tblTimePeriods which has the following data: ID, Name, ReleaseTime, EndTime. I need to retrieve data in a query within the selected time period. But, it wont be selected with the ID, but with a selected time. I was doing this with the Between ReleaseTime and EndTime...

In MS Access 2010 I want to create a kind of showschedule for a small cinema. I can't figure out how to create this correctly. This is what I want to create: - Week 26 (23-06 - 29-06-2005) Week 27 (30-06 - 06-07-2005) Auditorium 1 |> A1 A2 A3 E1 E2 E3 MTWTFSS >2...

For a new database (accdb) in access 2010 im busy creating a new submenu. In the past with access 2003 it was a bit easier and I can't figure out how to solve this. What is it what i want to create. It is a copy button, you select a day, lets say Thursday. If you push the button it gives you...

For an event database in access if have created a static overview of the planned events. It looks like: Auditorium Event Start Date End Date Milano EventMilona 01DEC2012 05DEC2012 London EventLondon 03DEC2012 06DEC2012 Per event I created a...

Can anyone help me how to set a custom Right Click Menu. Everyform must have a costumized right click menu. For example Form 1: - Duplicate Record - Delete Record - Show Details Form 2: - Copy Appointment - View Appointment - Close etc. But I can't figure out how this works in Access...

For a small reservation programm the system should generate automaticaly a bookingsreference. This reference should consist of a unique number and letters and a barcode. An example: TP9DBP773 (barcode 120283706847) Any one tips how to create a random bookingreference and a random barcode.

Since a couple of weeks I started to develop a new database with Access 2010 (.accdb). And somethings have changed. In my database I have the following issues which I can't figure out how it works. 1. Treeview Previousley I had a sample database with a preview of a treeview. Unfortnatley I...

I would like to create some functions to call the system info of the Computer. The following information is needed: - OS Name Already tried with: sOS = Environ("OS") but this returns the Windows_NT in stead of: Microsoft Windows XP SP3. - The computer information, displayed as: Intel Pentium...

In stead of a listview I have created a form with different subform which have the function of a listview. Now I want to create a listview as subform which should look like following: Name Monday Tuesday Wednesday Thursday Friday Saturday Sunday Weekend...

I'm creating a public function which determines if the selected date is a holiday or else which day it is. But It don't works correctly. I have made a table Holidays, with the fields HolidayName, Startdate, End Date: Public Function DagNumber(SelectedDate As Date) 'The following values have...

Is ist possible to copy a records with their childrecords in VB. I use the following record Structure Table 1: Ticketset Table 2: Ticketset_Pricetypes Table 3: Ticketset_DayRange Table 4: Ticketset_TimeRange Table 5: Ticketset_Rank Each record will contain multiple child records. I have...

Access 2007 has a great new feature with the multiple value field, unfortunately you can not access these ‘childrecords’ to add more fields or add another childrecord. For an already developed theatre reservation system they would like to create pricingsets. Which mean that for each show you...

It took some time, but I'll have created a 2-level treeview, but now for the first time I would like to go 5-levels deep, but trying to add the third level it gives me an error. Till now I have programmed: Function tvwTicketSets_Fill() On Error GoTo ErrorHandler Dim strMessage As String...

I'm willing to create a concession sales program in access 2007, but I'm stuck. The concessions program will have two different Items 1. Sales Items 2. Menu Items, which contains 2 or more sales items I have created the following tables: tblOrders - OrderId - Date - TerminalNo...

I'm willing to create a concession sales programm in access 2007, but I'm stuck. The concessions programm will have two different Items 1. Sales Items 2. Menu Items, which contains 2 or more sales items I have created a kind of switchboard on an Access Form with all the sales and menu items on...

I'm willing to create a concession sales programm in access 2007, but I'm stuck. The concessions programm will have two different Items 1. Sales Items 2. Menu Items, which contains 2 or more sales items I have created a kind of switchboard on an Access Form with all the sales and menu items on...

I'm am making a small programm for seat reservations. But I have a problem to find the sequence in the available seats. I will explain it with the following sample: Row Seat Total Seats In Sequence Sequence number Available 1 1 3...