Search results

I plan to use queries and SQL in any project and prefer them over VBA. However the real intent of the above exercise is pure academic. I am new to concept of arrays and am learning how to use them. I started from some YouTube videos and some codes from various sites. I downloaded a module from...

I have tables with numeric data which is needed to be sorted in increasing or decreasing order, or in reverse order; tables with string which is to be sorted alphabetically. True, I can do it by SQL but was trying something new. I tried the above code, it works if it is on the same form and not...

Hi. Thanks for your kind responses. I tried to make a module with a function (or a subroutine) to copy data from any one or two fields of a table of user's choice to make it a single or two dimensional array. This form would contain a textbox or combobox to enter name of table and field to...

Is it possible to pass tablename or fieldname as parameters for a function or subroutine?? I am trying to make a form with text-boxes - txtInputTableName and txtInputTableField which will make a one dimensional array out of user specified field on any table. Can someone help me regarding...

Thanks for the code. I tried this, but it shows type mismatch error(Run-time error 13), and (For Each vi In vArray) line is highlighted during debugging. Can you please help me rectify it? I am new to ADODB.

Thanks a lot for help. The code works great. I was wondering if my list box had multiple columns, and sorting was be done based on any one column, could this method be applicable?

The codes worked perfectly. Thank you. However, I planned to sort the contents of Right listbox by press of a button. I copied the contents of Right listbox in an array, deleted the contents of right listbox and copied back the array into this listbox, but I am getting empty list box. Dim...

Hello all. I am having some problems in moving data from one list box to another. I have attached the database below. Form 1 contains two listboxes, labelled Left and Right. My objective is to select multiple records from left listbox and move them to the right listbox. I can successfully...

Thanks a lot. I'll test it out and let you know.

Thanks I'll test this out

I am sharing the database as .rar file. 'tblCust' contains information about the customers - Name, Age, Address, Contact, Date of entry and serial number. 'frmCust' is used by user to add information to 'tblCust'. 'frmSearch' contains two text-boxes which are to be filled with date of entry and...

Thank you.

The fifteenth customer was an example. The main purpose was to generate a unique customer identification number. All other field contain data which may be repeatable so i tried to make a unique field which could be easily calculated by summing up date and serial number I had used a similar...

Thanks. I tried to make a query with name, address, contact, date and serial number. Criteria was set for date and serial number. Date and serial number were entered through a text box on a form, using '[Forms]! [DataForm]! [Dt]' and '[Forms]! [DataForm]! [Sr]' in date and serial number column...

Ok i'll try to search the two fields separately.

Yes it is in yyyymmdd format. The result is in number and variable type is Double.

In my main table I have separate field containing Date, serial number and the calculated field (Double data type containing the result)

Thanks for reply. I only intend to use calculated field in table is to add a sort of unique identification to each record. All the other fields contain data which may be repeated. As I intend to enter every customer on a unique serial number everyday (Starting from 1), i combined date and...

For example for 22nd September, 2020 an entry is made for 15th customer. Their name, address etc are stored. In calculated column, the number stored is 20200922015. On another search form, another user enters date as 22nd September 2020 and serial number as 15. The form should display name and...

Hi. I have a table with name, address, contact, zip code, date and serial number. There is also a calculated field in same table using date and serial. I want another form to be used by customer to enter date and serial only. The calculation are done in background and all matching record from...