Search results

Okay problem solved. 2 forms with same table as source. In my "users" table I have a field called LastSeen with the date, where a given user last accessed the DB. The value was updated by a hidden textbox on the main form when the user opened the DB. I Moved the hidden textbox to the other form...

Yup - one subform, with one more subform on each page of the tab ctrl. But only one form open for edit for each table. Most of the forms contain calculated fields anyway, so they cannot be edited... Funny thing is, though, that the table causing trouble is not being accessed by any form or query...

Hi all, I have a form with a tab ctrl with several pages in it. Some of the pages get data from DIFFERENT queries that get data in the SAME table. I get an error when I open the form, since the first time a form is open - or a query is run, it doesn't "close the connection" to the table again...

True :p - I don't use those names in my db. Just needed something short 'n' sweet to call it in the example ;) Thanks! Steff

Thanx Stoat :) That's been bugging me for weeks - and now it works!!! :D

This works: SQL="INSERT INTO Table1(name, time) VALUES('stringwhatever', 'another string');" DoCmd.RunSQL SQL

I searched the forum but can't find an example of "insert into" where the values aren't taken from another table or query. It's very simple: I have a function that assigns some string variables, str1, str2 etc. After that I want to insert them into a new post in my table, Table1. This doesn't...

Hi all :) Can someone post an *.mdb file with an example of passing a string value from one form to another (or a link to a previous thread where it has been done :rolleyes: ). Cheers! Steff

Still doesn't work... It is a ListVIEW not listbox... Can someone make the attached work?? Thinking outside the (list)box :rolleyes:

I'm taking a (long) shot at a customer database, with a search function. The search function I pinched somewhere on this forum (can't remember who was the father, but it's really neat, so thanks whoever you are!!!) I run into trouble when there is no match, and I attempt to clear the search...

Perfect! Thanks, and have a nice weekend :)

By the way: How do I extract the values again? ListView.ListItem(x) ???

So a sql query as sourceobject should work? Thanks! :)

I am using a ListView control (6.0 i think) to sort some strings. It has properties Visible=False and Sorted=Yes. Then I run a loop that adds items one by one, and then gets the items out again (this time they will come out in sorted order - the whole point of the operation) However, when i...

The plot thickens... I get a msgbox with correct content (the width) when I do; Msgbox SpreadsheetCtl.Columns(5).Width If I delete the msgbox part I get wrong number of args or invalid property for that object ... Still clueless :rolleyes:

I have an MS Office Spread sheet 9.0 control on a form (since the flexgrid wasn't available :mad: ) How do I set the individual column width? Have tried: SpreadsheetCtl.Columns(5).Width = 3 SpreadsheetCtl.Columns("D:D").ColumnWidth = 3 SpreadsheetCtl.Columns("D:D").Width = 3 Doesn't work...

I want to test if no records match the strSQL query. How is that done?? I have: strSQL = "SELECT bla bla...." Form_frmnavnogby.RecordSource = strSQL 'HERE it goes wrong... If Form_frmnavnogby.RecordSource = Empty Then Msgbox "There where no matching records" Form_frmnavnogby.RecordSource =...

I cannot change the event - it has to run on every change to the textbox. Will go with rubbernilly's solution - thanks ;)

How do I do that? I just want the focus set to the text box, ready to type further. I need it for the onchange event of the textbox but everytime I type a letter it loses focus...

Thanks for pointing me in the right direction :) ;)