Recent content by samehkh

We delete the tables every time and import them fresh from an XML file. Import specs works with text files, but I could not get Access to use it with XML.

I do not have control over that. When I import the tables from XML the field type is automatically selected. If I change the size after the import the date is already lost so it wont help.

We are importing data from XML files manually to an access Database. The imported tables are all text fields with field width 255. Some text fields are too big and we end up loosing some records as import errors. Is there a way to let access generate an imported table with a text field that is...

I had to use trial and error, I tried several things and it finally worked. For Each Box In RPT If (Box.Tag = "45") Then If (Box > 0 And Box < 45) Then Box.BackColor = White Else Box.BackColor = Grey End If End If What confused me a lot is that I declared Box as control...

I did not fully understand your solution. Can you please clarify the idea of using the tag property? I know how to loop through fields of a table using table.fields(x) but havent tried that with a report, especially that there is some labels and lines as well that I will need to skip. Thanks.

I am kind of in the same situation, but I am desiging a report for some test results of batteries, I have about 32 text boxes and i need to set the background colour to gray if the value exceeded a certain threshold. I would normally go like: if me.V1> 20 then me.v1.backgroundcolour= gray if...

Thank you!

That was a good idea, but in my case I am using an MDB file as the fron end, so it wont be able to copy itself when it is open. I also need to know if my idea of every user having his own copy of the .mdb front end makes sense, or is it better to have one file that everybody opens from the...

Hi, When I used to develop multi-user networked access applications, I used to give every user his own copy of the frontend. I was also the network admin at that time so I could easily create shares on users' machines to hold the application, and reach it from my desktop to update the file. In...

I actually changed the whole design now to read the parameter from a function GetDocumentNo() rather than a control on the form. At sometime i still had to enclose the function call in a Clng() but now seems to be working. Thats crazy. Sorry I lost track of the problem now as I changed the...

No it is all english.

Hi I ve been doing access programming since 1997, I've always used queries that read parameters from a form's text box or combobox or whatever, and this always worked for me no problem until, I started a new job and need to develop a small application to replace the paperwork I have to do. I...

Try IsDate()

Sometimes business rules dont allow serial numbers to be dropped, like in the case I posted (Invoice numbers)

This code helps solving the serial number problem in a multi user environment, where several users are attempting to take the same number. It depends on keeping the number in a separate table and then opening it one at a time with the "deny read" permisson. One User will be allowed in while...