Search results

The queries are used for some calculation like: if Query1 + Query2 + txtField > 6 then ..... But I don't know how to call these queries using the code. It might be an option to put the queries in the code, which I did, but now is the problem the queries need to be run. Is there some kind of SQL...

I want to run queries in VBA. The queries are used for calculations, but I can't find the right command to run a query. The queries are in the DB. Or do I have to type the queries in the code? Can ne1 help plz?

I have a statistics form, but I have one problem. The legend is not ordered like the x-axis. The x-axis is ordered by ID, but the legend is Alphabetically, and not by ID (its the name). How can I change this order, or how to change the query to get this order right. I tried to edit the legend...

OK, now I changed the code, so that when there's a new record, all buttons will be disabled, but they are still enabled... Here's the code I use Access thinks that the new record is the last record.. Can anyone help.. tnx Ironis

I disabled the standard record navigation buttons, so I have made my own add record button. The problem is not that I didn't define the code for a new record, but the problem is this: When there is no record, you begin on a new record, and then there should be no buttons enabled. When I have a...

Done that, and still using an input mask 99\-99\-0000;;_ But, now when I type 02-03-2002, (2 apr 2002) Access changes it to 03-02-2002, so it thinks my input is in the mm-dd-yyyy format, but I want dd-mm-yyyy becouse I use this format, and not for access to alter. I can't find how access will...

Ok, I got it almost figured The error I got was from the piece of code which defines the recordclone. That gave the typemismatch. Now I used both codes (mixed) and it works perfectly. Now the only little thing left is the following: When I have a new record, And fill in the first field...

I used the code from the tutorial, but I'm getting a type mismatch error. Can't figure out the problem. I also have a public function, which is used on every button on the form. This one checks wether a few checkboxes are checked, en if they are, the form shows specific subforms. When a...

I've got the US version of Access, I have to make an imput mask my own, but then still I get the US date layout, mm/dd/yyyy Maybe I can figure the date problem, but still not the automated check...

I want some queries to automatically look at the current date. I hqve some fields, which are text fields with the input mask: 99"-"99"-20"00;0; dd - mm - yyyy I want the system to find the current dat in this format, and then only show the reservations AFTER and ON the date of today, but I...

Hi I'd like to disable some buttons when I'm on the last record. I made browse buttons, and left the standard browsebuttons away. Now I want the "next" and "Last record" buttons to be disabled when the last record is on screen. Also, I want the "first" and "previous record" buttons to be...

Hi I have the following query: Select tblReservation.date, tblReservation.programcode_ID, Sum(tblReservation.number_pers) AS [Total pp Program] FROM tblReservation GROUP BY tbrReservation.date, tblReservation.programcode_ID It works perfectly. It shows the date of the reservation, the...

that sounds like a good solution, I will try it, guess it will work! Thanks!!

Hi, I'm having a little problem here I'm building a reservationsystem, and I'm quite new to access.. Nou I want a form to show a reservation, that works fine, but I want some additions to that. On the form, the following values are shown: Reservation# CustomerID ProgframID # of persons Pickup...

Thanx, It works perfectly now. I still have one problem on another checkbox: I tried to use the same code, but then the subform that pops up can't be used properly. It does open, and I can change everything in it, but it won't store the record, becouse it doesn't take over the personID from the...

I'm using the above code for a checkbox, but the subform that appears doesn't automatically go to the right record. When the checkbox is clicked, a subform will open with contact info, but it always opens the contactinfo with ID 1. So when I click the checkbox on a person with ID 120, it will...

I rather not use buttons, but I could use those.. What my question is, is if I can let access automatically determine the upcoming timeblock, eg its 1pm, so access automatically puts the 3pm block of that day on the screen, when someone opens a report, to see how many bookings there are for the...

Thats what I was thinking of.. But how can I manage that? Using a query or something?

Is it possible to let the main access screen disappear or hide, so that you only see the forms of the database, no tables, or links to tabledesign formdesign etc.. What I mean is that I don't want the complete access interface 'around' the dbase.. but only the dbase itself on screen with access...

Hey there I have a few questions, someone might now the answers.. I'm working on a reservationsystem, which needs to have multi-level users. Some users should only update and insert data, and shouldn't be able to read some data, like creditcardnumbers etc. But there should also be a user...