Search results

See this link on Microsoft: ACC2000: Referring to a Field in the Previous Record or Next Record

You don't need to triple-post your question to get seen! Likely you will get a message from the moderator... You should not have repeating groups in your table -- in this case it is the Months. Your table is not normalized. Hard to tell what you are wanting, but I'm guessing something like a...

Need to add error trapping for ZoomIn_Click() sub in frmPicExample. Specifically for error 2100: The control or subform is too large for this location.

Need to add error trapping for ZoomIn_Click() sub in frmPicExample. Specifically for error 2100: The control or subform is too large for this location.

Easier to put the code to open the form in the OnClick of the combo box. Then you are assured to have a value. To have an item in the combobox on entry to the form, in Default Value, put [comboboxname].ItemData (0)

From what you provided, it is very basic code. Add " As String" at the end of the function declaration so VBA knows explicitly how to return the value. 2. Does 'End Function' come after End Select or is there more code? I suspect the problem isn't with this function. Where does creditAttempt...

That's telling you that your control source of the textbox does not match any field names in the table. Open the form template in Design Mode. To see the full list of field names available, view each textbox's properties that #Name is appearing in. In the Control Source property, click the...

The way I got it to work was adding a table to which the textbox is linked to. Besides that, it was by the instructions. Demo MDB attached. I never ran across this problem, as I always code Editing/Adding a record in a form by itself -- not in the form with the continuous form view. That...

Nope. They are gone as soon as the Delete process completed. Only recovery is from back-up if implemented...

Mechele, aadconsulting.com has a free utility called Access Dashboard that will give you a tree directory view, with MDB's on the right. Double click an MDB file - if you have that version of Access installed it opens it; if not, it doesn't open it. http://www.aadconsulting.com/addins.html...

Glad I'm not the only one! :D After some perserverance I'm starting to get the hang of it myself. I refer OFTEN to Sybex Access 2002 Dev/Ent handbooks, amongst others (check Amazon for a good deal). Below is a sample routine that should work - just add your actions to take. This is the...

In otherwords, I assume you mean you have an Add button on form1 -- when pressed, it opens Form2 to add a new record... Sounds also like you are adding purchases or something-like.... Look in to the "stLinkCriteria" parameter of the DoCmd.OpenForm syntax - here is where you can pass the...

How about posting the code segment where you are trying this? Is maydate a Date/Time field?

To get your statement to pass in VBA:strSql = "SELECT Street.SID, Street.Street, Postcode.Postcode FROM Postcode INNER JOIN Street ON Postcode.PID = Street.Postcode WHERE (((Postcode.Postcode) Like """ & "*N1*" & """));" Am I correct that you are searching for postcodes that have the combination...

Hey Battenberg, Check out ELookup by Allen Browne. I figured out DLookup, found it aweful slow, then found Allen's Extended DLookup- MUCH better!

Hope this helps. This function is a "dual-purpose" design. You can call it to parse any filepath. Option Compare Database Option Explicit Function RemovePath(Optional filepath As String) ' 'INPUT : filepath to parse ' OPTIONAL - If not passed, default to filepath of...

With the data in the present form, the sort is working properly. You could: 1. Write code that would reformat the values on the fly. Not a good choice, overhead. 2. Manually change the values - abc1.3 to abc1.03. If you don't have too many records, this would be good...

In each test where you build the strValidate, put & vbCrLf at the end, with the exception of the last test.

[ No one has replied yet???? ] Rather than go to all that code, why not create a field CustNameShort set as 'No Duplicates', and allow the customer to type what they choose - affording them the ability to remember the ID better?

And, if you want to see the rest of the Environ variables available: Sub EnvironList() ' Warning: Never refer to an Environ value by its 'number', as you ' will get unpredictable results. Always include the Environ Name ' as in the GetWinUserName function. Dim i As Integer...