Search results

I think this sounds better: VBA code that parses the string to an array and then loops the array to add items to listbox Do you have any code for this ? which loops through table records one specified field and insert into listbox ?

Please find attached screenshot which will make you more easy for you.

I think you did not understand my question quite right, I have text field which takes values as Test1 Test2 .... After being saved this in the table, I want listbox on another form should display all the records certifications and should remove duplicates. Thanks

Hello I am creating resume builder database, now in that in the resume table I have created a field called "Certifications" which is type of text and user can enter any number of certifications. I also created one form that is bound resume table based query and allowing user to enter the data...

Thanks but question here is not of value population of combobox the question here is I am not able to select 2nd value in the list.

Hello I have combobox which has been bound to query as row source and control source as table field, but it does not allow me to select item other then first in the combobox list.. I am displaying form as datasheet. The value of the second combobox is depend on first combobox if I select A in...

I see forms's Movable property is set to No but I can not change it Yes anyways it automatically sets to No even if I select Yes I am using MS Access 2010.

Hello I have table which has several columns what I would like to do is I would like to have them drag and anywhere user wants but that should save to that order when user comes back. I remember this was happening earlier but now they can drag but when they come again they see that order has...

since currenttime is date value we have to bound them with "#"

Thanks Paul and Mark and all I figured out what was issue, below works fine for me ", [History] = [History] & CHR(13) & CHR(10) & 'Archived on ' & #" & currenttime & "# & ' by ' & '" + sUser + "'" & _

", [History] = [History] & CHR(13) & CHR(10) & 'Archived on' " + currenttime + " ' by ' & '" + sUser + "' " & _ error no 3075 syntax missing operator Full line of code sUser = UserNameWindows ' MsgBox sUser currenttime = Format(Now(), "dd/mm/yyyy hh:mm:ss") SqlQuery = "UPDATE...

I am still getting error on second line when i am concating existing field value, what is wrong.. SqlQuery = "UPDATE tbl_AllRequests " & _ " SET [Status]= 'Archived' " & _ " WHERE [ID] in (" & selectedIDs & ")"

Actually I needed both they can select what they want plus they can select all if they want..

This works but how to select all the records instead of selecting one by one..

Thanks but my query is how to append value to existing field using SQL vba.

Hello I am trying to update audit trail when there is multiselect status update to few types of records, and I want to update the status ="Archived" and also want to update audit trail of each record which has audit trail field. but I am getting error missing operator. sUser = UserNameWindows...

My issues is that I would want to show them this table as just for view purpose and they want to see the dates in table of sqlite in dd/mm/yyyy format. ( I will be showing sqlite table as odbc link table in ms access )

Hello I am using sqlite as backend and ms access front end application. there are two questions I have with this development. I would like to store the attachment in sqlite from ms access ( like native functionality of ms access ) how to make this possible ? as in Sqlite we dont have...

I would say it is query that holds approved documents , I would like to have option to select recotd/s and archive them.

Hello, I have view called approved documents, wherein I have all the approved documents having status called " Approved" as status. What I would like do is want to select the documents in that table and make the status ="Archived". I am not sure in table how I can select the record, please...