Search results

Babakuki, Import of a csv file should be done with a TransferText action in your macro, and using an Import Specification would be a great idea.

Captgnvr, There is no reason why using a query to restrict the records shown on your form to the current month, would prevent the entry of new records. How did you construct your query? One way is to make a query, based on your sale_details table, and then in the Field row of a blank column...

Adam, No, Access 2010 web applications require a SharePoint Server. Aren't all the computers in "the shop" networked?

Rocco, At no point does your code set a value to the 'answered' variable. So it will evaluate by default to 0. And thus neither of the options 1 or 2 in your Select Case code will apply.

Dave, What makes you think it is a .xls file? As for the column F idea... no that's not it. Access names any columns in the source file that are not included in the destination table as F1, F2, F3, etc.

Tezread, Am I correct in my understanding that this crosstab query is a saved query? If so, try this: CurrentDb.Execute "SELECT * INTO NewTable FROM YourCrosstabQuery"

MADali, I'm sure this is familiar to all of us! Well, not quite. Try it like this: countrecord = DCount("*", "Customers Data", "[Sales Person] = '" & valueSalesPerson & "' And [Next Action Date] => Date()") By the way, what is valueSalesPerson?

Babakuki, Can you try to import this file into a new table, which will help to identify where the problem is coming from? I assume you are using a TransferText action in your macro. Do you have an Import Specification defined?

Norm, I suggest you completely remove this code you have on the Format event of the report's Detail section. And remove the other control (textbox?) on the report that points to the image. I suggest you simply set the Control Source property of the Image control to the field that contains the...

Jillie, Export to CSV should be done via the TransferText method. Try that.

Fuz, If DCount("*","QueryFormIsBasedOn") = 0 Then ...

lzfy, If you want the frmZorgfuncties2 subform to show all Zorgfuncties records related to the current Klanten record on the main form (do you?), then your data structure is such that the Zorgfuncties record will have to include a Klantnummer. That means that this subform needs to be based...

Irunergoiam, I generally tend to only Dim a variable if it is going to be used more than once in the subprocedure, the exception being where the definition of the variable is complex or long, as in the case of the strSQL variable. I can not see that the repeat Dim of the variable can cause...

lzfy, Ah, I think I see what you are talking about. On the form Klanten1, you have the subform frmZorgfuncties2 bound to the table tblZorgfuncties. This subform has no entry for its Link Master Fields and Link Child Fields properties.

lzfy, When you say "when I create an entry in table A, table B sees this but C doesn't", can you give an example of what you really mean here? What is the expected behaviour, and what specifically is happening that is different from expectation?

Suradj, Ok, well if you mean for the message box to be triggered when you navigate on the form to the record, then this is the Current event of the form. So put your code there. As pointed out to you elsewhere, you should be using the Date() function instead of the Now() function. But in...

Suradj, The After Update event of what? If you mean the After Update event of the HireDate control, then this will only happen at the point where you enter some date in there, or edit the date in there. As I said before, you need to decide when you wnat this to be triggered, and only then...

Suradj, The "date of today" is returned by the Date() function, so in that sense PNGBill is quite correct. However this is not going to explain the #Name? error. Can you confirm that the name of the field in your table is HireDate with correct spelling? And that the HireDate field is...

Pnealen, Yes, in my original response, I have just focussed my answer on the specific question you asked. However, I agree with vbaInet and DCrake, that the concept of using DLooup functions to get data into bound controls on your form appears to indicate another problem with your database...

Suradj, If the message box would be better, then do the message box. No problem. But you have to clarify when you want the message box to appear. This will happen in response to an event. I guess the most likely options would be the After Update event of the HireDate, or the Current event...