Recent content by x0reset

No, just delete and import the entities you modified.

Are you using a separate query or did you build the query in the data source of the report? I would start by making sure the query is built in the data source of the report. Then add two parametric fields to the query: StartDate: [Your first parameter prompt] EndDate: [Your second parameter...

Try setting the "Can Shrink" property to "Yes".

Instead of entering an age, you need to select an age range. (lkpAgeRanges) Specify a ClassID for each class. (lkpClasses) Relate your AgeRangeID to ClassID. (lnkAgeClasses) Your tables should look something like: lkpAgeRanges ------------- AgeRangeID LowerAge UpperAge...

Short answer: you can't. If the calculation is taking place in a control on a form the form must be active for the calculation to take place. Good news though! It sounds like instead of going through this convoluted calculation process you just need to use the totals row in your forms...

You need 4NF table structure for this one. lkpAgeRanges ------------- AgeRangeID LowerAge UpperAge lkpClasses ----------- ClassID ClassDescription lnkAgeClasses --------------- AgeRangeID ClassID LowerScore UpperScore This enough or shall I elaborate?

Your talking about doing calculations between records instead of between fields. Tough to do! This is the ONE situation where I have found it necessary to store a calculated field. My solution: 1. Add a field to your table, call it ConsWeeks or something apt. 2. Create a new form, set the...

RunSQL only works for transaction queries, your trying to run a Select query. Instead try using an aggregate function like DCount.

Okay, Question 1: I recommend not using a query. Use the ApplyFilter command instead: Private Sub YourButton_Click() Dim stFilter as String Dim stMsgRslt as String stMsgRslt = Msgbox ("Your message here"...) stFilter = "[PO]= '" & stMsgRslt & "'" DoCmd.ApplyFilter , stFilter End Sub...

Well, here is where I would start: lkpRooms ---------- RoomID RoomDescription RoomTypeID More room fields... lkpRoomTypes --------------- RoomTypeID RoomTypeDescription RoomTypePrice More room type fields... lkpFacilities ------------ FacilityID FacilityDescription lnkRoomTypeFacilities...

If your not comfortable using VBA you can use the "TransferSpreadsheet" option in the macro builder. You may also find it helpful to know that exporting a spreadsheet with the same name as an existing spreadsheet will automatically overwrite the old version.

First, what ARE the relationships? One customer can have one room? Many rooms? Can one room have more than one customer? One customer can have one booking? Many bookings? Can more than one customer have the same booking? Can one booking have many rooms? Many rooms have many bookings? Do...

Look for the "Row Source" property of the combo box. You should see a little query builder button appear next to the property when you focus on the property box. Click that button to build a query, then select the rows to include in the combo box and choose which sorting options you would...

So in other words, if your users want to see data for a single day, they must enter the times as well as the dates. If they want to view multiple days, they do NOT have to enter the times as well as the dates.

I have been working with Access and database programing for about 6 years now, and I still don't know what fourth and fifth normal form is. Anyone have the time to jot out a brief definition/description for these and any other advanced levels of normalization? I am hoping this might point me...