Search results

Can I ask what the & "" is all about ? I think "CUSTOMER_ID = " & id & "" Should be "CUSTOMER_ID = " & id But maybe I'm missing something? Also, can you explain the use of & "" here as well? If Len(dumStr & "") > 0

I'm interested in seeing how this one is resolved because I can't think of anything.

Can you tell us how you accomplished the first part?

Well there is a problem with the logic in your code. The steps that you need to take are roughly as follows: 1. Check to see if data is entered into the UserName combo box If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required...

Is this a continuous form?

Ah, good find Djkarl/JANR, I missed that syntax error.

Strange behavior indeed, not sure why it allows you to set a string to Nothing if you have an unused string variable.

Are you just trying to clear the variable? I don't think you can set a string variable to Nothing (only objects can be set to Nothing IIRC). I usually do something like test1 = "", but that just makes it a zero-length string I believe.

Where will users input the data that goes into the smaller form? Your subform already has the Add New row at the bottom, if users enter data in there it will create a new record.

There is a problem with the syntax in your department DLookup code and your case statement. First of all, in the employees table, is there a column for department? How do we know which department an employee is in? You DLookup for department should follow the syntax of your password DLookup...

I think WinHTTP might be of help to you but unfortunately I can't offer any help on how to use it. Maybe someone else can elaborate?

A quick way of doing this would be to take the username and lookup the department of that employee using DLookup, store that in a variable, then do a select case on that variable for each department. Here's a rough incomplete example of what I'm talking about: strDept = DLookup(lookup syntax...

What protocol are you using, FTP, HTTP ?

I'm not sure I understand the request. I've looked at the access mbd that you posted but I'm still unclear as to what you are requesting. Do you just want to add a new record to your subform and insert some data into this new record using the parent record as the source?

I think the only way to do this is to use an unbound form instead of a bound form. With a bound form, closing the form, switching fields etc... will all trigger a save. If you used an unbound form for people to input the data, then created a save procedure that inserted a new record into your...

I think you have to commit the record before an autonumber is assigned. In SQL Server it's called Identity btw.

Yikes, I'm slower than I thought, there were no replies when I started mine.

Can you describe to us what you have done so far? And what is the name of the function and the button? Without any further information I can't be of much help. I can say that roughly the steps are to create your function, then in the OnClick event for your button you will need to call the...

Is it possible that the control value is being modified through VBA instead of the form control, thus the AfterUpdate event is not being fired so he is calling it explicitly?

The link I posted to Allen Browne's ELookup outlines the shortcomings of DLookup. In my experience, the only issue I ever had was the DLookup function returning a null and that can be handled by either using the isnull() function or the Nz() function.