Recent content by Nevy

Ah, that's what the second parameter is used for. I've just tried that and it still gives me wrong IPs. I can't change the decimal delimiter. By default it's a dot, and I need it for other values. And what is a "manual text import routine" ?

Hi when I import the CSV file, everything is ok, except one column, which contains IP addresses. So instead of having 10.195.7.252, I gets truncated to 10.195 or 10.1957 I'm assuming it as to do with the dot, and it's taking it as a decimal... The frustrating part is that if it's done...

Thanks. It worked.

Hi, I want to use a module for creating a window file broswer, found here. It is going to be use to insert an excel file in a table. The problem is that when I click on cancel, it gives me an error since it doesn't have the string of the filename. How can I correct that? At first, this is...

Hi, I want to run two queries, one to delete, the other to apprend. If I call them qryAppendX and qyrDeleteX. How can I run them using the code? Can I simply write: DoCmd.OpenQuery "qyrDeleteX" ... DoCmd.OpenQuery "qryAppendX" ... Thanks

Yes it is, since it's working. Thank you!!! But I've used Froms![MainPage]!checkOne instead of Me!checkOne. Yes, the form is open while the report's opening. But it's working now. Thanks again.

Sorry, I don't want to sound like an idiot, but I don't get it. I'll show you what I've wrote. This is found in the form: Dim strTotalExp As String strTotalExp = "" ' sL, dL, sLt, dLt refers other textboxes in the report. If (Me!checkOne) Then strTotalExp =...

It's the second choice " you trying to set the control to the expression so that it does the maths? ". But I still get it as text.... And for the control source over value, I don't think you can set controlsource after or in the print preview. Anyways, I'll try to figure out it's not working...

Hi, I'm trying to create a simple pie chart to get the distribution in percentages. The values are the sum of the fields. I can't seem to add more than one field in the chart. What am I doing wrong? Thanks.

strTotalExp is the combination of 4 fields. Depending on what the user chooses, strTotalExp can be a combination of A, B, C and D. So if the user chooses A and C, then strTotalExp is A+C.

Thanks. It worked.

Well it's not really specific to VBA, it's more to programming. Sometimes, I have more trouble with what looks simple... I want to create a string of the type: "=(A+B+C+D)" A,B,C and D are optional, meaning the user can select whichever they want using checkboxes. Here's a simplified...

Cool. Thanks. The only problem is that it's printing as text. Is it because the string contains errors?

Hi, I want to insert an Expression in a text box of a report using VB. This is what I wrote in the code builder section of report header. Me.totalBox.Value = strTotalExp Me is the header section of the report. totalBox is the textbox. strTotalExp is the expression that I want to enter, it...

Thank you. As you mentionned, all I needed was to bind two fields together. Now it works.