Search results for query: *

A star for you Duane, thank you very much your way is so easy to do and very easy for a relative amateur like me to understand. Thank you very much.

MajP, Once again thank you You did indeed show me this before, but with your help we had modified it so that it you could book a room per day with no time internals. Now of course a bit over a year later they want the time intervals and I had lost your original sample. however the link...

After a nearly 2 weeks trying to figure this out, I think I am almost there. I have the form setup with a record source of tblRooms and set to be a continuous form. This gives me all the room details. I then created 26 unbound fields (1 each to represent a 30 minute time period) eg: 6-6:30 ...

my appologies, the form is set up (but I am open to changing it if required) with the time fields on the Y-axis and the rooms on the X-Axis, this way you have as shown below 8-830 830-9 9-930 930-10 10-1030 Room1 Booked Booked Room2 Booked Booked Booked Room3...

Thanks but I am looking to display it on a form,so if I can get the query to work right, i can use that as the bassis of the form.

Some time ago with the help of people here I manage to create a booking system for my work to be able to book rooms. This has been in use very successfully for over a year now and everyone is happy. Now however they want to be able to book the rooms in smaller time amounts. Currently things are...

you can change the line <ribbon startFromScratch="true"> to read <ribbon startFromScratch="false"> this will leave all the default tabs on the screen, but also include your new tab.

in your ribbon XML you will need : <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <contextualTabs> <tabSet idMso="TabSetFormReportExtensibility"> <tab id="MyTab" label="Home"> <group id="ListCommands" label="Main...

I currently have the following code in the AfterUpdate() event of my form DoCmd.SetWarnings False DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True Of course this works fine and does exactly what it should, what I would like to know is if it is possible to have the same spell...

Hi all, I am a newbie with Citrix and am having a problem with the login script. When a user logs into citrix it runs a login script that is different from the network script. Is there a standard location for these scripts ? or a way to find out where on the server they are located so that I...

You can still use Access, if you have a full version, you can design your database complete with all forms and then install the runtime version of Access onto the users machine. The runtime version can be downloaded for free from the Microsoft website.

I use a reg file to insert the location as trusted directory into the registry when installing the database. just insert the text below into a notepad file and save as a .reg file Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted...

This is (to me) a real strange problem. Firstly I have a database coded to relink some tables on starting, it works without an issue. Now I am creating a new database and would like to use the same process, so of course I copied the code form the original working database to the new one and now...

fldNetValue is taken direct from the table so not calculated, not sure what the problem was, but a compact/rebuild seems to have done the trick. Thanks for your help

I have searched and searched and cannot find anything that would help explain my problem. I have a continuous subform with a field (fldNetValue) on it, in the form footer I want the total, so obviously the answer is to have a calculated field with a value of '=Sum([fldNetValue])' of course...

the code provided is typed (copied) into a notepad file, save the notepad file as filename.reg and have the users run that. It will insert the details into the registry for you, without you having to go into reg edit. After that you can just run your mdb/mde file as normal and you will not get...

you will need to add the database as a trusted location. I use a small reg file to do this, just copy the code below to a notepad document and save it with a .reg extension Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted...

This would appear every time there is a change in the combobox as with each new selection you are changing the entire row ie: ID, Name, Type

in the 'onchange' event of the combo put the following code intresponse = MsgBox("You are about to update the record, are you sure ?", vbYesNo + vbQuestion, "Your DbName") If intresponse = vbNo Then 'Exit routine Else 'make your change...

I dont think so, create a filename.reg file in notepad with the following: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\DbName] "Description"="DbName" "Path"="C:\\Path1\\Path2" then have your user run this, or have...