Search results

Hey there I've got a problem with some queries. I want my queries to get a certain calculated value, but there is a problem. One querie has 2 fields, 1 record as an outcome, the 2 fields are outcomes of two other queries. Now when one of the values of the other queries is null, the 'final'...

Hey, I have quite a problem. I want several users to view the data of a table through a form, but when the accidentally open the Database Window, I want to prevent them from reading the tables. How can I do this? The reason is that people can't read creditcardnumbers from the form (ecouse its...

Hey there I'm quite new to using reports or programming reports. I want a report, that shows lines, like a word table.. In the table I want to have m,ultiple records appearing. I cannot get that fixed using a query or whatever, but I think this needs programming. I have attached a Word File...

Hey there I want a textbox on a form, which encrypts itself when a certain user is using the DB. The encrypted text is a vreditcard number, and I only want the last few numbers to be visible. I already figured out how I can 'detect' wich user is 'online,' But I don't know how top make text...

Hey there I have a form, which is hidden. The form starts up using the AutoExec macro. I want on other forms, to deactivate certain buttons with certain users. I do this using the following: In the macro, the form opens, with a table in it with user names en workgroups. The where condition...

Hi, I want to create my own error message on a duplicate record. The problem with the normal error message, is that the text is very long, and for users sometimes not understandable. So I want to create an error message, with 'normal' language, instead of the technical error message there is in...

I have a little problem with a msgbox. I have predefined the style like this: Style2 = vbYesNoCancel + vbQuestion + vbDefaultButton1 I defined the next code, to give the commands to each button on the msgbox, but it doesn;t work properly. If you enter vbNO, it will trigger the vbCancel...

Sorry, 3rd question this hour, but I need the answer ;) I have a few MsgBoxes, and I want the text to be on multiple lines. How can I do that? I know it can be done, but I don't know how. This is the code I have on one of the textboxes: Msg1 = "There are " & spce & " spaces available." &...

I have a planningsystem, which has to plan A-groups full, and after that B groupd. The code calculates if the A-group is full, and will then suggest first other times for reservations, and then if not available it should open a B-group. Now i have two options: 1) Making an 'invisible' checkbox...

FormCode to Module or Class? Hey there, I have a question. I'm working on a planning code, but it seems to get a bit long. Now I want to put the code into modules or classes, to make it more clear to review etc. Can I do this? and if so, how can I do this?

Hey there. I don't know if I'm using the right forum now, bu I have some questions about security in Access 2002 (XP) I am building a reservations database, and I also want prepare it to track payments in the future, and when there are email or fax reservations, the system has to be able to...

Hey I've got a msgbox code error, which I can't figure out.. Can anyone help me? here's the code: Private Sub E9AMLess6() Dim space, enc, swim, enc2 As Integer Dim Response As VbMsgBoxResult Dim Msg, Msgs, Msgss, Title, Titles, Titless, Style, Styles space = 18 -...

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

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

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

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

Hello, I am quite new to access, and i am working now on an internship, building a reservationsystem. A function which needs to be in the system, is an automated timeblock assignment. Like when someone wants clicks a button, a report will appear, with the reservations for the upcoming...