Search results

wow! I think I have to study a little about string handling in vba - for not reinventing the wheel every time Thanks Guus

Since there is a separator character between the numbers, while assuming that your string starts with a comma and that there are only numbers and commas, you can do something like this: Sub RetrieveIntegers(FiveIntegers as String) Dim CurrentChar as String Dim i,j, IntArray(4) as Integer...

Hi, You may refer to the control's properties with Me.Controls(strCheckboxName).PropertyName

Hi, In case you do not want to actually hide the combobox when the user clicks on it, one unorthodox but still working way is to set the focus to another control (maybe an invisible "dummy" one). In this way, the combobox will lose focus and the list will not be displayed. There must also be a...

Hi, Before proceeding to the solution, I would like to make some remarks. 1. The expression [First Name] = "Tom" AND [Last Name] = "Jones" will return ONLY the records with First Name Tom and Last Name Jones, that is 2 records in this case (assuming that 2 {Tom Jones, MEX} and 2 {Tom Jones...

I'm very glad I helped! Many people have already helped me directly or indirectly and I also try to help as much as I can - in the limited time I can spend. This is what the forums are for anyway!

Hello fau5tu5, Take a look at the attached file, which works as desired. It seems the problem also was that you used "cboSearchField1.Value" instead of "txtSearchValue1" (where the date should be in the filter string). I suggest that you also take a look at the other file within the rar...

Well, In case you want the user to be able to search on 2 or more date fields at the same time, you will need 6*2=12 text boxes (Date1Start, Date1End, Date2Start, ..., Date6End). In this case you just have to repeat the code 3dman proposed 6 times (one for each date field - an alternative and...

Hello, I guess that you could print the document through vba to the "pdfCreator" printer. Unfortunately I do not know if there's a way to bypass the two pdfCreator windows that will pop up (asking for pdf file name, attributes and path). Have you considered opening the doc file in read only...

Hello, I had the same issue some months ago, but this format didn't work correctly for me (it filtered wrong dates). It probably is correct in most cases though, as I have already seen it in many forums, but maybe the format also depends on the computer's regional settings. In case this...

Hello again, I think that using a loop is necessary for what you want to achieve. Please let us know if you find another way! As you have probably already figured out, you can apply a set of actions to the desired objects (those having a specific attribute) by using an "if" or "select" clause...

Hello, I think you need something like this: Dim ctl As Control For Each ctl In Me.Section(acHeader).Controls If ctl.ControlType = acTextBox or ctl.ControlType = acComboBox then ctl.Value = Null End If Next This code for example will set all textbox and combobox values to...

Hi again, I am really sorry for almost giving you a heart attack :D Basically this is a small part of an application that is intended for internal use. So, in short, the user groups will be the following: 1. Admin 2. One or two users with full permits - high ranked employees - who will be...

Impressive. Thank you very much Leigh! I will try the solution you propose, but I have to read first to get more into collections and objects in VBA. But let me ask one more question. What I would like the user to do when creating a new report is only entering the report's description as...

If you have included a primary key field, let's say "ID", in the table with the AutoNumber data type, the latest record created will have the largest ID number

Thank you very much HiTechCoach for your fast response. This is also what I thought, until I tried the following, which worked: Let's assume we have a report named rptReceipt. In case the report doesn't have any code associated with it in VBA, just right click in any point within the report...

Hello all, I am trying to create a listbox which will show the captions of all reports in the database. In order to do this, without having to load and unload each report by using the Reports collection and taking up time and resources, I think that I have to use the "Report_<Name of Report>"...