Search results

Hi all, im trying to use thi but it doesnt seem to want to work for me. I added the control (shimgvw.dll) but when i use the command everyones been suggesting on other posts Preview1.ShowFile "<file path>", 1 I just get the error of 'Object Required' The properties in the control (of which...

Im a little troubled by something, i need a button on a form that, when clicked, will check my database [Info1] for cell irregularities and post the results in a table. I can manage this easily enough with 1 query but i need several of these to be done via the click of the button but dont wish...

Just bumping this incase anyone can help?

i will heed this, and have Changed to DateJoined :)

Hi, I have a query im wanting to run on a table but i cant get the syntax to work with it. Im trying to get it to display records where "Date" is populated, and any of the other cells listed in the query are populated (be that 1, 5 or all). E.g Date ="01/01/01" Name = "" Surname = ""...

The document im linked to in order to change the data types (update.xls) is updated often. Aslong as the names correct then the link will work. If ever an extra column is found though, id like an error alert. If this is not possible with the current setup its ok, would just be a nice addition.

That worked fine, thanks :D Just as a side question, is there a way to compare the initial spreadsheet with a another tables column headings? so i could pop up an error message when there are'nt matching columns before running the query?

Thanks for the tips! Ill need to run this query every time a button is pressed though, what might the command be for this?

Hi all, I have an xls file i want to import into a table in my access database, but i need all imported data types to be text and no primary key included. I know you can achieve this with a txt/csv document but need to ensure this with this xls. atm im using the simple command to import in...

Ok well i have a form which reports on a table, so you type in a number, click search, and the record is displayed. This record contains a document page, date, name and comment (TEXT). Clicking on this displays the full comment in a new form (is too large for listbox). frmReport Private Sub...

Thanks for the help, i have it working :). A question for future reference, if i didnt have TEXT in the first column, how would i specify that its text that i want displaying? Forgive me if im wrong but appears only the first column is displayed in this click method. Thanks again :)

Hi, I have a listbox in a form that displays some info in columns (lstNotes). The fourth column contains text that is too large for the listbox so im making it display the full text in a seperate form in a textbox once clicked. I however cant seem to get this to work. Private Sub...

np, i appreciate the offer of advice :) So if i cant alter the widths to accomodate the table info i.e Me!lstNotes.ColumnCount = 5 Me!lstNotes.ColumnWidths = "1cm;2cm;2cm;2cm;60cm" Then what alternative is there? If there is one :x

Just to confirm, its a List Box i have, not a Combo box, the sizes i find in the properties assign to the width of the list box itself, and the width of the columns inside, these inside colums being the ones i want to enlarge significantly.

Hi, I have a listbox that displays values from a table when one of those values is selected in another listbox. This all works fine however there is a line in the table that is, long to say the least. I have changed the values in the listbox width to 1cm;2cm;2cm;2cm;60cm (5 columns,60cm...

Hi DCrake, yes i was aware of Aircode and did realise that it was theoretical and that i would need to adapt it to working as you did on the quick without testing and was very much appreciative of the fact that you did this. I have identified that the problem is with AND placed after each...

Hi, thanks for the response, it works fine for clicking search without entering criteria, though, when i typed in a surname to search for, it returned a syntax error in the from clause, apparently its with strSQL containing: SELECT * From tblMember Surname Like 'Johns*' AND ORDER BY...

Hi all. I am using a form that checks a table for results based on the cirteria entered in the textboxs provided. This currently works fine for a table i have where all 4 columns are populated. Im now using a table that has many null values, yet running the same code only returns values where...

i see, 1 extra ", something so simple :( thanks for the help, i shall heed your warning of the US date, its a simple tool for one user so shouldnt be an issue too large if ever occurs

Hi Namliam, appreciate the comment but dont believe that to be the case as using the following: ObjConn.Execute "select * into tblMain from dboADD_HIST_DATA where DateCreated >= #" & CDate(strDateC) & "#" Does produce the correct result (in this case, DateCreated = 12/01/2008) and the error...