Search results

Hi, I have a form with a text box. I am using this to enter a date. I have set it up as a short date with the input mask 99/99/0000;0;_ I don't need the time. Is there a way to set up an input mask just for the date?

Thanks, Can you point me to any sites that I can educate myself on temp tables?

I will be populating the form with 25 fields

Hi, I am populating a form, named form1, with data. I click on a command button . I do a bunch of calculations and then display that data in another form2 . I don't have any tables associated with either of these forms. I can do all of the above with the exception of displaying form 2...

I have a form with an options group with 3 checkboxes. Also on the form is a command button. The command button calls a procedure when clicked. How do I test for the value of the option group in the called procedure. Thanks.

Ganz, You are right. I changed the logic and it works. One more favor. What are the color number for yellow and green ? Thanks so much

Click on properties the following is displayed. Text Box: BuyOrSell Under All Tab Name : BuyOrSell Control Source : BuyOrSell Under Data Tab Control Source: BuyOrSell

The process is as follows: Click on a command buttom and display a form with the last record on the database. The code is: I click on a command button, it executes the following procedure: Private Sub Command11_Click() DoCmd.OpenForm "currentbuysell" End Sub The on load event for...

My mistake, but it is not a text box that I want to change, but the field on the form is a data field . How would the with statement work with a data field. Thanks,

Access 2000

GanzPopp, Thanks for responding. I new to this, you could please be more specific? Where do I put this code? Aslo please give me an example as to how it would be written. Thanks.

i'm new to Access , could you please explain. I click on a command buttom and the datasheet displays. Where would I put this code?

Is it possible to change the color of a data filed in a form based on its valu?e I execute the following when the command button is clicked. docmd.openforms "inventory" if a field is less than 0 I'd like to display it as red otherwise display as green. Is this possible?

Hi, I was travelling and could not respond. But I tried the following. I am getting nowhere Dim mysql As String mysql = " INSERT INTO Signals ([datedaily], sw, c) " & _ "VALUES (#" & mydate & "#, " & BuyFlag & ", " & rut & ");"...

Hi, I really need help with this. I added a new field to a table. Changed the CurrentDB.Execute statement to include it. Now I am getting a run time error 3061 , Too few parameters. Expected 1 . Code before the change. CurrentDb.Execute "INSERT INTO signals ([datedaily], sw, c )VALUES...

Hi, I can't figure out what I' doing wrong. This code works: It loads 5,000 records into the table CurrentDb.Execute "INSERT INTO OTCBU ([seq#],[datedaily],[RUT] )VALUES (" & reccount & ",#" & xDateDaily & "#, " & xrut & ");"...

This is an Access Data Base. The data for the report is generated by vba code. The code loads the date and an indicator into the table. There is a record for everday since 1/1/1991 throught 5/18.2012. There has to be an answer for this .

I deleted the first 250 records . Now the last 250 show up. So what is the problem. ? Why can't I see all the records in the report ?

I tried SELECT * FROM Signals Did not work. Same result

Hello, I am using Acess 2000 I have a table with 5,386 records in it . It is not linked with another table and has no primary key. It is a stand alone table. When I do a query , all the records appear code: SELECT [DateDaily], [sw], [c] FROM Signals; If I use this query...