Search results

Hello, Am I doing something wrong? I extract the file and I can't open it, when I try to open it from Access it says I don't have the permissions needed. Robert

Hi Sara, I tried your procedure, and it works just like it should. Your problem may be further down where you won't let them continue if it is more than 35 days old. So your "If strinput2 < DateAdd("d", -35, Date) Then...." line tells it if it is less than 35 days (i.e. 36 or greater) then...

From The A2K Developer's Handbook: "At some point, you may want to change the size of a check box or the character displayed within the check box. You can't. If you want to do either of these things, you'll need to create your own hybrid control that looks like a check box and acts like a check...

Hi Steve, The only thing I could think of is that you have one message box in your form and one in your subform. Whatever the case, from the main database window, click on forms. Then click the code button on your tool bar, this will bring up all event procedure and wizard created code for all...

Try the NETWORKDAYS: NETWORKDAYS Returns the number of whole working days between a start and end date, excluding weekends and any identified holidays. If this function returns the #NAME? error value, you may need to install msowcf.dll. Syntax NETWORKDAYS(start_date,end_date,holidays)...

Try surrounding your name with square brackets. Also it is recommended that you never use and characters other than letters, numbers, and underlines. If you do you have to use square brackets (This includes spaces.) [COMPANY_ID-Status].Enabled = True HTH Robert

Hi Richard, You can do this easy enough without any VB. On the properties sheet for your date control (Text Box) set the default value to Date(). Then set the Locked value to yes. HTH Robert

Hello, Try something like this: Public Sub Test() DoCmd.RunSQL ("INSERT INTO table3 (1,2,3) SELECT tblActionItem.ActionItem, tblActionItem.SerialNumberID, tblActionItem.ActionItemID " _ & "FROM tblActionItem;") End Sub This worked for me. The underline is Access's way to continue a single...

Hi Helena, The problem has to be that you are not passing a date in. Your Dlookup statement works just fine. I changed it to a procedure and ran it with some fake data and it passes. Public Sub Testing() Dim BHDate As Date Dim X As Variant Dim BankHol As Boolean Dim str As String BHDate =...

Hello, I looked in the developers handbook and there doesn't seem to be any code to clear the window. My recommendation would be to have your last line of code be a string of "--------------------". This will give you a break point. Also if you are using the immediate window it will only...

Hey Homer, Try this create an event procedure on the command buttons click event. Type me.text2 = me.text1 If you want to clear text box 1 then just add after that me.text1 = "". HTH Robert

Hello, Your code is kind of confusing, but first of all Access won't recognise just a field name. It will give you an error of an undeclared variable. Try using ME.ControlName for all of your fields (ME.Priority). This tells Access that you want the form you are working on and to take the...

Hi Mark, Try this: If switch = "name1" or switch = "name2" then That should do it. HTH Robert

Hey Doug, It may be that you have both the ADO and DAO libraries as references. Try leaving it out, I went through about 50 examples in the developers handbook and they have stopped using that dim statement. I believe it is now implicit in AK2000. HTH Robert

Hi Cindy, Try under Tools --> Database Utilities Robert

Hi all, I have a form with cascading textboxes, that select a group of records. The records open up on a subform. What I am trying to do is when I have a particular recordset open, I would like to hide any columns that are not being used. For instance in the practice contacts database that...

Open your form in design view, and right click on the upper left corner of the form and call up the proreties for the form. Go to the events tab and choose OnLoad then hit the ellipse (...) to the right of this box. This will take you to the VB screen, now just type: msgbox "Whatever you want to...

Yep, under properties on your form, you can put it in the default value space. Or you can do it in the table under design view. HTH Robert

Hi Andreas, You are making your life way to difficult. First if your form is based on your employee table, then you don't need to add it to your SQL statement. So on your properties page for your combobox set your record source to jobnumber (Since your form is based on employee table it will...

I believe in the KISS method of database design, if you want the report to default to all try this. Set your text field beginning date to something like 1/1/1935, and your ending date to 1/1/2029. Then the user won't have to enter anything to get all the data; but if they want to specify dates...