Replies

Taking a flyer….

I believe you need single quotes, not double quotes, around the VAR part of your code (as you’ve declared tham as strings). (Also took out the space before SELECT, but not sure if that’ll make any difference?)So…

SelectionSQL = “SELECT tblStudent.StudentID,tblStudent.Name,tblStudent.StudentPassword FROM tblStudent WHERE (((tblStudent.Name) = ‘” & Var1 & “‘ AND ((tblStudent.StudentPassword) = ‘” & Var2 & “‘)))”

Hope that works

Thinking about it…is there any other control on the form (eg. a Close Form Button), because you could give it the focus on form open (or make it the first item in the Tab order) and thus avoid changing any settings.

It sounds like you have specified a format for the txtBeginDate2 control (or the relevant field in your table) and the value of strBeginDate2 doesn’t match this format.

It looks to me (and I may well be wrong, but safe in the knowledge that someone will point it out if I am! ) like the value you are trying to pass to this field is actually only 6 digits, without any formatting (ie 022102 instead of 02/21/02). So, either remove the Date Format from the text box (or field) or try using something like this to make sure that strBeginDate2 is in Date format. Something like:

strBeginDate2 = Format(iMonth, “00”) & “/” & Format(iDay, “00”) & “/” & Format(iYear Mod 100, “00”)

(I’m not sure if you should be declaring strBeginDate2 as a Date instead of a String)

Hope that helps..repost if I’ve sent you off on a wild goose chase.

The only option I can think of would be to change the settings in Tools/Options/Keyboard from ‘Select Entire Field’ to ‘Got to Start of Field’ in the Behaviour Entering Field section.

If there’s something else you could do to change it without changing these settings, I’m sure someone else will pipe up…

Thanks chaps,

I’ll try recreating this at home this evening (I’ll set up a long path and try it with and without spaces) and see if I can replicate the problem.

Cheers

Where are they ‘dropping off’?

If it is the last few characters in the field, I have had similar experiences in the past, but it was easily resolved by increasing the physical width of the controls in the report.

If it’s something else, repost with some more information.

Cheers

or put in some error trapping that moves to the next control

using Mark’s code:

txtTextBox.Value = txtTextBox.Value & vbCrLf & cboComboBox

where ‘vbCrLf’ gives the carriage return

I have just duplicated this problem (I think ) in Access 97.

In the Microsoft Graph area set up, where you specify that the value axis should be currency, try ‘un-ticking’ the ‘Linked to source’ tick box.

Not sure how this affects the actual values that are displayed, but it did cause the pound sign (in my case) to be displayed.

If you’re new to Access and prefer to keep away from the code, the easiest option is to base your report on a select query (if it isn’t already) and in the design view of the query in the criteria for your unique id field add
Forms![Your_Form_Name]![Unique_ID_Field]

Then, as suggested previously, use the wizard to create an Open Report button on your form.

This way the report only shows the record currently visible on your form without you needing to amend any code.

I started off using Step by Step Access 97 Visual Basic, Microsoft Press, ISBN 1-57231-319-6.

Found it easy to follow an reasonably well laid out.

Try reading reviews on somewhere like Amazon, or failing that, nothing beats paging through the books at your local bookstorelibrary

Try something like

=”Compiled By ” & [Forms]![master]![compiled by] & ” as of ” & Date()

assuming that the field ‘compiled by’ is on your form ‘Master’ and the form is open.

I’ve never succeeded in resetting an autonumber field.

The only solution I’ve got is to go into the design view on the table, copy the autonumber field, paste it at the end of the list (in the same table), delete the original autonumber, move the new one back to where the original one was and save.

HTH

Is the form ‘Master’ open when you’re running the bit of code?

Paul, correct me if I’m wrong, but it sounds to me like you’re using the File , Save As option within the database in order to try and save the database to the floppy. This will only save whichever object (Table, Query, Form etc) you currently have highlighted. (This is what I assume you mean by copying from “basket” and only getting the “bare bones”)

If this is the case, if you need to copy your whole database to floppy (with all its relationships etc. intact), you need to use Windows Explorer (otherwise you are only going to be exporting 1 table/query/form/etc rather than the whole database).

With regards the copying of data within the tables, are both fields the same format (ie/eg is 1 field a 255 character text field and the other a date field)?