Search results

At this point in my (early life) coding experience, I feel really silly having to ask, how do you get the name of the table source for a current form or control (field)? I've been looking everywhere and can only find info on, for example, retrieving path and directory names, all tables in a...

Uncle Gizmo and Brianwarnock - Yes, yes, yes!! Thank you very much. It would have taken me ages longe to figure it out. The sample goes beyond what I'd originally wanted (ref to single table), but what you've provided offers *loads* of possibilities for future projects! Ta very much, Christine

I've got a form with 3 RTF controls to get info into memo fields. Editing the form is limited to authorised users. So, on the OnOpen event of the form I've got: If mCurUser <> CheckProcessOwner Then Me.AllowEdits = False This sets every field on the form so they can't be edited...

I don't know if it is against "the rules" to repost, but I haven't received a response to my question posted yesterday (11-Oct) and need help asap. I would like to create a button on FormA which will open FormB. Easy enough. However, I want the data source for the (single) field on FormB to...

Update: I just created a new memo field and dropped it onto my form and used the field's on double-click event to run the zoom command. It worked. However, this zoom box, nice as it is, won't meet my needs since (a) it's too small and (c) the text box I'm zooming in on is a rich text control...

Hi again, Rich. Well, that command certainly would be lots easier, but I can't get it to work! Since I'm using the command button to call the zoombox, how does it know which field I want it to zoom in on? (I can't use a double-click event procedure, etc. since it is being used for something...

Hi, Rich. When the user clicks the command button, it will open a form to give a full-screen display of a memo field. I figured it would be easier for users to edit and read the contents when there's lots of information in there. I want to be able to use the zoom form for a variety of forms...

I would like to create a button on FormA which will open FormB. Easy enough. However, I want the data source for the (single) field on FormB to vary depending on the variable I set in FormA. Can someone tell me how to to do this? Here's the code in FormA that I have thus far: Private Sub...

I’ve gotton myself completely confused with relationships and need some help. In tblCARs I have a field called OwnerID. OwnerID should get its value from tblProcesses, which has the following fields: ProcessID (autonumber) Process (a descriptive text field) OwnerID (gets its...

Help with expression with 0 numeric value - Thanks Thank you, Ken - that did it! Silly me really should have figured that out before!!

Could someone help me with an expression in a report? If the value of DispositionID (a numeric field) is 0, I don't want the 0 to be displayed - it should just show nothing. The closest I've been able to come is shown below, but obviously it is trying to show an empty text string (" ") instead...

The OnClick event for a cmdbutton sends a report to a SNP file. Whilst this is happening, Access displays a message that says "Now outputting... <file name and path>. I don't want this message to display, especially since there is a Cancel button on it! :eek: How can this message be...

Expected variable or procedure, not module - SOLVED! I am so pleased to report that the problem is solved! Many, many thanks to all of you who helped. Peter's last comment about Cancel et al was the final piece in the puzzle. You guys are the best! Christine XOXOX!!

le error - Expected variable or procedure, not module Ordinarily, yes. However, at the request of users, I've had set up the form so that users can create a Corrective Action Request (CAR) and leave it incomplete until a later time when they can come back to edit it. Unfortunately, this will...

Oops, the file didn't attach. Here it is. BTW, I tried Rich's suggestion If Not mdlCheckForNulls(Me) Then Cancel = True End If but still receive the same error.

Thanks so much for looking at this for me! Cheers, Christine

Thank you. I'm still getting the same compile error. In the form that calls the function, I've changed it as I *think* you said to do about changing the line to "send" the function call: Private Sub cmdSend_Click() ' Call the module mdlCheckForNulls to ensure all form fields are complete...

Still awaiting help - Compile error: Expected variable or procedure, not module I hate to appear impatient, but could someone respond soonest concerning my problem and last post? I played with the code this weekend, to no avail. :confused: Thanks so much, Christine

Thank you for that, however perhaps I wasn't as clear as I should have been. You see, I need to get the value of column 2 of the field from the table, since the value doesn't appear on the form. Thanks, Christine

Complile error - Expected variable or procedure, not module Thank you for that. Sorry if this is going to be a silly question, but I'm very new to all this. I've changed the name of the module, as you suggested and changed the code to this Public Sub CheckForNulls(frm As Form) ...