Recent content by helenlou

If you are using a form, you could try setting the forms properties to allow additions but not deletions or edits. Look at the Allow Edits, Allow Deletions, Allow Additions properties. If you are not using a form, not sure how you can do this. H

Try using Str(<your long integer>) Might help to define the variable you are assigning the value to as a Variant rather than a string too.

I am using a linked table into an Oracle database. I run a report which is based on a query on this table. If the user does not enter a valid username and password to access the Oracle database or cancels the ODBC password prompt, the event code continues anyway. How can I capture the cancel...

Not sure if you can do this with a macro but even if you can, if you have any data in the tables whose field types you are changing, you'll have problems. Changing data types on data already in the tables is not recommended!

I am saving a report as an .rtf file so the Excel solution isn't a goer. I want the dialog box to default to a parent directory but the user can then choose any directory beneath it or above it as they please. Thanks for the help! H

Thanks for the link but is it possible to get the folders window to default to a file location other than My Computer? Otherwise I am no better off than leaving the filename in the Output method blank which automatically prompts for location and filename. I had a look at the code but I'm not a...

Is there a way I can save a report to file (pref using the OutPutTo method), prompting the user for a filename and directory location but displaying the file save dialog box with a default location. The users will mostly be saving files to the same location and it would be nice to avoid them...

No worries - have got it to work without using DCount. Must have been a problem in refering to a subform control. Thanks for your help! H If Me![Campaign Test Cell subform]![Test Cell Number] = 0 Then msgBoxResult = MsgBox("You must specify at least one Test Cell before upload", 48...

DCount doesn't seem to work - I get an "Invalid use of null" error. This is the code I used: If DCount(Me![Campaign Test Cell subform]![Test Cell ID], "Campaign SubForm_Query") = 0 Then msgBoxResult = MsgBox("You must specify at least one Test Cell before upload", 48, "USER INFORMATION")...

I have a main form with a button which performs an action. The actio should only be performed if there are records in the subform (i.e. that there is at least one record relating to the record in the main form). Can anyone help me write the VB to do this check? I've tried all sorts of things...

Thanks a lot! It works a treat! H

I have some code which will set this property to false to prevent users from accessing the underlying database structures and menus using the SHIFT key. However, I need to specify some kind of key combination which will allow an administrator full access (as the SHIFT key would if it was...

Don't have time right now to look at this detail but perhaps you could try using a cross-tab query? Might be a start. H

In the Field cell of Postcode in Query Design View type something like this: FirstFive: Left([Post code],5) This will create a field called FirstFive which groups Postcodes according to the first five digits.

I have a report comprising of several sub-reports. Each subreport has field labels as well as the data which are displayed when previewed separately. However, when placed as subreports within another report, the field labels disappear. I've looked everywhere for options that determine whether...