Search results

If EmpID is Numeric If DCount("*", "YourQueryName", "EmpID =" & Me.EmpID) > 0 Then DoCmd.OpenForm "FormName", , , "EmpID =" & Me.EmpID Else MsgBox "No Matching Record Found!" End If If EmpID is Text If DCount("*", "YourQueryName", "EmpID ='" & Me.EmpID & "'") > 0 Then...

Private Sub Form_Current() Me.YourButtonName.Enabled = False End Sub Linq ;0)>

Why not simply set the Column Width of the Columns showing the Ship Dates from tblPaymentsto to 0? Linq ;0)>

Are you familiar with the PtrSafe Function when working with 64bit? https://docs.microsoft.com/en-us/previous-versions/office/office-12/ff700513(v=office.12) Linq ;0)>

MajP has given you the syntax. Rather than using If...Then, it's better to use the Select Case construct...like this: Private Sub YourTabControlName_Change() Select Case YourTabControlName Case 0 'First Page is selected 'Code for first page goes here Case 1 'Second Page is...

What you're attempting to do here, essentially, is store Data (in this case the year) in the names of your Tables...a definite violation of relational database rules. You are talking about a Relational Database...not a Spreadsheet app! Linq ;0)>

Commonsense would dictate that the Data Entry Property, set to Yes, would simply mean that you could...enter data! But, despite it's name, Data Entry Property, set to Yes...means that you can only enter new data...you cannot view previously entered data! Just one of Access' many quirks...

No reason you should have to create a Textbox on the Tabbed Page before cutting and pasting an existing Control on it...not really sure what is going on, there...but here's a hack for automatically 'reconnecting' moved Controls to their Event Procedures: Courtesy of ADezii, at Bytes.com, this...

Don't really understand how you can use an Unbound value (Consultancy Rate) as part of an expression to get another Unbound Value (whatever the sometimes errant Control is called) on what has to be a Continuous Form (going by your attached image.) The rate will always be the same for all Records...

That be correct! Linq ;0)>

Just as an explanation...you were using conditional formatting...notice the Lower Case...as opposed to Conditional Formatting...off of the Ribbon. While you see txt_stat multiple times, on a Datasheet or Continuous View Form, you're actually only seeing multiple instances of a single...

As Dave Letterman used to say..."What???" Two Tables having the same Fields makes no sense...it violates Normalization! How can a single Textbox 'have a list of table?' In order for us to help you, you need to give us a plain language explanation of what you're trying to do...not how you're...

Why not simply DoCmd.RunCommand acCmdSaveRecord 'In case it's a new, unsaved Record DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdPasteAppend Linq ;0)>

Well, 30+ members have read this post and not responded, and I'm guessing that, just like myself, they can't begin to understand your scenario, as posted. But, in general, this error usually pops because of one of these two reasons The app is in a multi-user environment and is not split into...

As theDBguy said, if all of these Controls are Bound to a single Field, in the underlying Table, then all of the Textboxes (txtcheck, txtCash, ect.) will show the same Value...and you won't be able to tell how payment was made! You need to either use arnelgp's method, with a Combobox, or use an...

I think that the only other way would be to set the Form's BorderStyle Property to None, then create a Label, up against the top of the Form...set it's alignment to your desired one, and set it's background color to look like The Form's top would if you didn't have the BorderStyle Property to...

The RecordSource of the Form being opened is not also the RecordSource of the calling Form...or part of the RecordSource of the calling Form, is it? Linq ;0)>

Is [Total Costs] an entered value...or is it also Calculated from other Controls? It sounds like the latter, given its name. If it is Calculated, you need to use that Expression times QTY. Linq ;0)>

And here as well http://www.utteraccess.com/forum/index.php?showtopic=2051360

Glad we could help! Linq ;0)>