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

Just thinking... Is it possible to create a pivot table in MS access, displayed as form/continuous form?

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

Many many thanx MajP! The problem was the reference of the Microsoft Office 14.0 Objects. You code is really terrific, used it several times in older databases and it works perfect, easy to change. The original database was lost, so thanx for uploading it again!

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

Thanks for your answer. I googled the context menus but still I didn't found a solution. I know how to build out in access 2003. But it seems that you have to build it entirely in vba. I need some help how to start. I tried it but the context menu stays empty. I used the add menu command.

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

Thanks, have tried it, but won't give me the wanted information. Only the computer name could be retrieved with wmi...

No haven't tried it, as this database will run on differrent computers and the mentioned programm isn't installed on them. I can only install it on my pc. I was hoping to retrieve it from the system info in the config screen... No succes yet.

Please find here a image of what I mean: http://www.4shared.com/file/257370082/6537fde6/Form_Tab_Day_and_Time.html The first column states Active, this allows you to add or deleted records to a specified table. The second column states Titel, this is the name of the specified DaySelection...

This continues form is used as a list view which allows you to add records to the selected table. The Days as above are only for fast reference and a wuick overview which DaySelections a approriate. Please not I know only mentioned Weekend, Daily and Weekday, but there are a lot more and not al...

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

Thanks this demo is very helpfull, except, the form isn't shown as a continous form. On your form you use Weekend, Weekday and Daily but these are the names which I use as a record. For example: Id Name ChildId Day 1 Weekend 1 Saturday...

I would like to create a kind of schedule to make a quick selection on which days something is valid. In the above mentioned Output the X is representing a checkbox an must always be in the same order. I will use a continues subform that can be readed horizontally (on which day is the...

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

Thanks! Just added : DateSelection = Format(SelectedDate, "yyyy-mm-dd") and now It works great!

Thanks for your reply, you are correct there where some typos in it. But I just figured out what went wrong. Visual basic uses the Month - Day - Year format. If I use this in my field as SelectedDay it works perfectly. But We work with the Day - Month - Year format. So when I set the Date to 1...