Search results

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

I am trying to make a query with two tables. Each row consist of a student ID, their name and all their personal information. Both tables are exactly the same. But one table is a link table. That link table gets update every so often from an outside program and the other table is not linked...

Thanks I got it

I have a text box that has an Input Mask setup. The box is format to be ##-### (00\-000;0;). My problem is, when the user clicks in the box it does not start at the beginning, it starts where ever the user clicks inside the box. Is there way to for when you click inside the box it...

I have a command button that brings up a report on my form. After the report comes up and the users has viewed it and printed it, I want a message box to come up saying "Are you done with the report." But when I set up the message box it comes up right after the report comes up. And the user...

Never mind I figure it out. I misspelled response. Thanks anyway

In the Form its the command button called "Command 37"

VB Script Below is my VB script Private Sub Command26_Click() Dim intResponse As Integer intReponse = MsgBox("Are you sure you want to clear the boxes?", vbYesNo, Change) If intResponse = 6 Then Me.chk9 = False Me.chks10 = False Me.chk11 = False Me.Chk12 = False...

Thanks again for your help. I just have a few questions. What does the "Change" mean after vbYesNo? Why is there a 6 after the IF intResponse=6, what does that mean? I tried using your VB, I put it in and I get the Yes No screen, when I hit Yes nothing clears.

I actually figure it out but yours help. Is there anyway to change the fonts of the message? I try to play around with it and all it changed was the command fonts. And at the top of the message box it says Microsoft Access, anyway to change that?

That is a good idea. You happen to have the VB for a message box too?

Thank you, that was helpful

I have a one page form set up into 4 different sections. Each section has its own command. First section is Radio buttons with a drop down list. The next three are text boxes. I have a rather simple question, next to my OK command button I want a to create a button that will say "Clear" and...

Amazing Wow! That worked. I never really thought about setting up that way. I knew that my default value was wrong. Once again thanks for your help on another problem!

It may be a good idea but its not the look they are looking for. I am actually not going to use checkboxes but instead radio buttons but I know they are one of the same. Thanks for your help anyway. I will try to fumble around with IF statements and see what I can come up with.

Here is SQL of the query SELECT [tbl STUDENT DATA - ACTIVE].SchoolDistrict, [tbl STUDENT DATA - ACTIVE].Grade, [tbl STUDENT DATA - ACTIVE].First, [tbl STUDENT DATA - ACTIVE].Last FROM [tbl STUDENT DATA - ACTIVE] WHERE ((([tbl STUDENT DATA - ACTIVE].SchoolDistrict)=[Forms]![frm Grade/District...

Ok I see what you mean when I have the text box, and it switches between 1and 0. But how do I get it to work? It showed me how it goes between -1 and 0

I understand what you are saying but why do I need a text box?

I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together. When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does...