Search results

My ISP is Cox. @ridders What's yours?

Thanks for answer and for trying to get this fixed. If you need to follow up on this please mention that my account (sneuberg) needs fixing too. I'd appreciated it.

Just run the query and see if you can edit the field that you are having problems with.

@ridders Did they get this fixed for you? I'm still not getting email notifications.

You could disable the Status field by adding another conditional formatting rule like: The only thing is that the user will have to know that he will have to move the focus from the ActionedBy field before the Status would be enabled. This would work better if you could move the ActionBy...

I suggest checking the underlying record source query of the form to see if it is editable. There are a variety of things that will make a query uneditable.

This Access 2016 specification states that a SQL statement is limited to about 64,000 characters but I don't see any other limitations about functions.

I suggest trying the full reference and the parameters collection. Something like: qdf.Parameters("[Forms]![frmOrders]![OrderNumber]") = [Forms]![frmOrders]![OrderNumber] in place of qdf("[Forms]![frmOrders]![OrderNumber]") = Me.OrderNumber.Value

or by De Morgan law: Not((AssignedTo="Customer Care" Or AssignedTo="Production" Or AssignedTo="Logistics") Is another way of looking at it.

One way to make a text box do this is just make a DLookUp the control source of the text box. Since the combo box is current being set to the ID of the user then I assume it must be available. So the control source of the text box would be something like =DLookUp("[UserName]"...

I'm buried in a Web PHP/MySQL project. I'll probably won't be posting much for the next six months. Anyway it's been about five hours and I haven't received an email concerning this thread so it appears I have the problem too.

The second section of the input mask controls whether the mask parts are stored. This says this about that. But if every field is going to have that prefix what is the point of storing it? I'd just prefix the data with it when you output it.

I think I've been seeing (or not seeing) the same thing. Please respond to this post and I'll let you know if I got an email notification. I'll put it on my calendar to check this thread tonight.

If you have the customer ID I think you should be able to iterate through the folder and for each file name used the Instr function to determine if the file name contains the customer id.

You can join two tables based on a function. In the attached database I join two tables with a function I created name Match. The query looks like SELECT Table1.ID, Table1.F1, Table2.ID, Table2.F1 FROM Table1 INNER JOIN Table2 ON Match( Table1.F1,Table2.F1); Note that because of the function...

I think you will need to get the date for the criteria in a subquery something like SELECT * FROM TheTableName WHERE Admissions < 1 + (SELECT TOP 1 Admissions FROM TheTableName ORDER BY SortField); where the SortField would be which ever field would get the right record on the top. You could...

You may need to adjust your references. For example if you had a reference to a form control let's say named cboMyCombo that was Forms!NameOfTheForm!cboMyCombo with the navigation form (assuming you didn't change the default names) it would now be: Forms![Navigation...

You could create two listboxes and use the button to toggle which one is visible.

Error 3464 or "Data type mismatch in criteria expression" implies [Course Name] is something other than a string. I suggest checking type of the field [Course Name].

If you want a double quote in a string you need to double it. For example. Dim strQuote as String strQuote = "He said, ""This needs two quotes ""." So I suggest using the VBA editor to double them up. Just press Ctrl H and replace " with "".