Search results

The bonus of not using tab controls is that you can format and colour your forms exactly how you want, without having to have a big ugly grey strip going through your form

I have a table of projects, and a table of project coordinators. each exists once within its own table. I have created an intermediate table that sits between the two ie ID, ProjectID, ProjectCoordinatorID That way you can use the intermediate table in queries to achieve for example, a list of...

Another way is to draw one subform control on your form and call it ctlDisplay. You will find that you can change its .sourceobject property via code rendering tab controls pretty much obsolete. e.g. Private Sub ViewProjects_Click() Me!ctlDisplay.sourceobject = "FormName" end sub Using a...

For reference: The correct syntax for copying values from for to form... Forms!Form1.Form!YourFieldName = Forms!Form2.Form!YourFieldName *-)

Does anyone know how to programmatically check a field for decimal places? My users will be working in thousands and should only be able to work in thousands. They can currently enter 1.5 into a text box, and I want to catch any potential errors... Any help would be much appreciated

Try this ("SELECT count(recordid), [history type] FROM tblHistory WHERE tblhistory![recordid] = '" & Forms!frmMain.Form!ID & "' AND [history type]= '"Compliant "' ") Hows that? [This message has been edited by Jimbob (edited 04-09-2002).]

Did you just import a form? If so, chances are there is a module you need to import as well... Sounds like the code behind the form is looking for a Public Sub or Function (Bit of code) that isn't currently in your database...

Don't know if this helps but I use a little form to run all my timer events from. It opens with the db but is minimised, and made so it can't be seen. Go to the form's properties, put a value in the Timer event (default 0) like 5000 for example, then bring up the 'OnTimer' event code window...

What kind of field is RecordID? is it a text or number field? it's already referred to as a criteira in the SQL code... I'm a bit confused, can you give me alittle more detail? [This message has been edited by Jimbob (edited 04-08-2002).]

I get an error when I run the following code. The error is "Microsoft Access can't open the mail session. Check your mail application to make sure it's working properly" This is the code: Private Sub Command112_Click() Dim db As database Dim rsEmail As DAO.Recordset Dim strEmail As String Dim...

No worries

Hmm, can you post your code here? ps I'm in Nottingham too :-) Nice day innit?

Have you tried working with the recordset ie populating some text boxes with it's values? I ask this because I have a similar line of code in one of my db's, and although it retrieves records.....the recordcount is always 0, or 1. Odd I know, I'm a bit of a novice so I can't explain this.... I...

I'll just have to try again then... try this instead set rsSet = dBase.OpenRecordset("SELECT * FROM tblHistory WHERE recordid = " & Forms!frmMain.Form!ID & " ") if ID is a text field then do this: set rsSet = dBase.OpenRecordset("SELECT * FROM tblHistory WHERE recordid = ' " &...

How many fields are there?

try this instead set rsSet = dBase.OpenRecordset("SELECT * FROM tblHistory WHERE recordid = " & Forms!frmMain.Form!ID & " ") if ID is a text field then do this: set rsSet = dBase.OpenRecordset("SELECT * FROM tblHistory WHERE recordid = ' " & Forms!frmMain.Form!ID & " ' ") *-) [This message...

Just an idea, but how about adding a Now() field to the table? That way all you have to do is find the record with the latest value in the Now() field and return the ID... ??? [This message has been edited by Jimbob (edited 03-28-2002).]

Do you have accecc '97? if so, go to the debug window, tool, references...check your references are like so: Visual Basic for Applications (Ticked and at the top of the list) Microsoft 8.0 Object Library (ticked and second on the list) Microsoft DAO 3.51 Object Library] Has that sorted it...

If you really wanted to you could convert all your queries to SQL strings and call them from vb, i.e. on the 'OnOpen' event of the forms you could open a recordset (using SQL and vb), then use command buttons e.t.c. for moving through the recordset and populating your fields from the recordset...

Thanx Fizzio... Has that fixed it Haytham?