Search results

m001, Put the "long" code, all of it in a new module and call it something meaningfull. Then call the function in the module from a command button. Place that call in the "on click" event. That should do the trick.

Danno, If me.check1 = -1 and me.check2 =-1 then "do something" end if If me.Check1 = 0 And Me.Check2 = -1 Then "do something" end if As you can see, instead of using true use -1 and instead of using false use 0. Also, I would put the statements in the After Update event of the check boxes...

My regional settings are correct (GMT -5 eastern US). My tables don't have a default value (default value is empty), and the reason I don't use "=Date()" in the default value field is because I use the form for two purposes, one is to get data and the other just to display data. When the user...

Thanks Oldsoftboss, but doesn't work. For some reason the parentheses after Date are removed by the compiler after I finish typing the line and the date keeps on being 12/30/99. My pc's date is up to date. Any other ideas? George

Hi all, Can anyone tell me why this line of code gives me 12/30/99 and not today's date? Forms!frmMain!txtAnalysisDate.DefaultValue = Format(Now(), "mm/dd/yy") Thanks, George

Thanks Wayne, but I also try those values (they were the first I tried) and still I have to "reclick" my boxes to make them true to Access otherwise it won't see them as checked. Again, thanks for your time. Do you have any other ideas? George

You can put code behind the exit button so that it checks all the necessary fields for empty values and prevent the form from closing. This will force or alert the user that he/she is not finished entering all the data. You can also hide the "x" button so that the user is forced to only exit...

Thanks all for your replies, The check boxes are not bound. I use them as user options to print the report that is being generated. If the check box is checked (default value) then the report will be printed after being created. Else, it won't print. No records are created in this case; it's...

Hi all, I have a couple of check boxes in one of my forms. I set their default value to =1. The problem is that when the form opens my code does not see the box as being checked untill I recheck the box. Why isn't Access seeing it checked? Thanks, George

How about having the user enter a number. For example, If user wants option 1 then he/she will enter "1" in the appropriate field. And so on... Hope lights the way George

Make a copy of it, remove any unnecessary records and forms from the copy, compact it and try again.

Help does not shed any light on the issue, and a search on Microsoft's knowledge base was no help either. Maybe if you tell us where you saw the entry might we get on the rite track. George

You said: "how would I lock the entire 1st form, including the subform, but will allow me to type in the search control " My approach is to use code to lock just the controls I need to lock and leave the rest editable, in this case would be your text or combo box. You said: "(cuz when you lock...

Hi jeremie, I tried using the subform method you suggested but had problems making the subform to work (I thought it would be a straight forward operation). The way I got it to work was using the InsideHeight property for the main form and setting my controls to visible whenever the button is...

Hi all, I want to recreate one of those forms where by pressing a "Advance >>" button a hidden part of the form shows with its controls. I tried doing it in the footer of the form so that the button just makes that section visible, but I don't get the same result. Then I tried resizing the form...

I had a similar situation. What I did was to copy the vb code from the macro in Excel and pasted it into the code in Access. It worked wonderfully. That way the macro runs in the sheet that I'm creating. Give it a try, George

Hi, I haven't tried it with a macro but below is the code that I have used to export data to an Excel sheet. Play with it so that you get the dessired results. '******************************** 'Start of code tells Access to create a new Excell workbook Set ExcelApp =...

You are absolutely right rockman, I realized it after posting the code and went throug it. Thanks for posting though. Regards, George

I used to have the field as text but changed it to number as I didn't have that sort of numbers. I took your advise and changed it back to text for a mask would not work since most of the time I wont be using the hyphen, but now I get errors somewhere else in the code. This is the code I use...

Hi all, My table has a field which requires numerical data entered. I need to enter something like "58971-1". The table is updated through code. This type of data causes the data type mismatch error at runtime. Is there a way to tell Access that this is a number? Maybe through the use of a...