Search results

In the AfterUpdate event of the Control that defines if the field has to be enabled or not: If Me.Field = "Value" Then Me.YourField.Enabled = True Else Me.YourField.Enabled = False End If

search in the forums for Cascading combo... There is anoter example Here

Yeah have had that one before.. Try Private Sub Form_BeforeInsert(Cancel As Integer) If Not IsNull (Forms!frm_Menu_Create_CR!cbo_Parts) Then Me.[Part Number] = Forms!frm_Menu_Create_CR!cbo_Parts Else: End If End Sub

Try this: Me.Yourcombobox = Null [CODE]

Not a very elegant workaround What you need is to set Conditional formatting, unfortunately Command buttons do not support that feature.. Maybe in the next version of Access :confused: Well there is a work around to that, but before let me state that Ihave found that putting controls inside...

Then is much more easier... See attachement

mmm I think it could be something like (from the top of my head) : in the OnCurrent Event of the Subform If Me.Checkbox = -1 Then [Forms]![YourForm].[Yourbutton].Enabled = True Else [Forms]![YourForm].[Yourbutton].Enabled = False

can you post a stripped sample of your DB? I think I get the Idea, but it would be simpler if you give us a little sample to work with

Not quite sure, but it could be the Autoactivate property. Anyway, storing pictures on a database has shown to be not a very wise practice. I would suggest you to store the Path of the picture and have the image bound to the path of the picture.

Hi, Welcome to the forums.. It depends on what you want to do.... 1. If you only want to disable the button after clicking it is fairly easy, but then everytime you step in a different record the command button will be back to its original state (enabled) 2. If you want to disable the...

If I understand you correctly, you need to print the records that have the checkbox received unchecked, is that right? You need to base your Report on a query that select the records that have No on that field, and criteria to select only the records for the supplier on the screen. As I told...

Let me ask in which case would you want to alter the design of a form on runtime? I am sure there are ways around watever conditions that needed to be met to avoid the headache of doing that.....

You can add controls and set their property to Enabled/Disabled or Visible, and set their values on during runtime operation.

You can go to Form Properties and under the "Other" tab, set Cycle = Current Record.

Do this on a brand new blank db just for the sake of learning... This may be your entrance to the wonderful world of writting code. Follow the steps carefully... one by one.... If you are stuck at a particular step, just chime in and we will get you through it... Do not worry it is easier than...

There are several ways to tackle this issue, this is just one of them: Create a table with one colum (date/time) and imput the hours you want to appear (06:00AM, 07:00AM...etc) Make a button on your Main Form. Create a query that append the hours and take the Primary Key on the form for the...

Yes it does appear, actually is the last page of the report. Page 12 in the first time out of field report is another report (Summary) based on a different query. Go in design view and expand the bar, there you will see the report.

See Attached Sample. Open the first report in design view, there are really 2 reports in there based on 2 different queries on the same table. At the end where you see the report footer, there is a bar... that is the 2nd report embebed in the 1st.

Yes ptaylor-west, you got it, play with it and let us know if you run into questions...

In order to do that, there must be a clear relation between the two databases, like a field that will allow ACCESS to ID where the information is going to go. After you have ID that specific relation between the 2 Dbs, set up a 3rd DB import tables from both Dbs and do Append queries between...