Search results

Is their ID always before the first < ?

Here is a generic example with a select statement using combo boxes SELECT transaction.SupplierID, transaction.UnitsBought, Format([TransDate],"dd") AS tdate FROM [transaction] WHERE (((transaction.SupplierID) = [forms]![form1]![combo0])); Is that "dumb" enough or do you need more?

it should be For lngRow = 0 To Lst.ListCount - 1 Lst.Selected(lngRow) = True Next LstSelectAll = True

This line? Public Function SelectAll(lst As ListBox) As Boolean You need to call it using SelectAll(yourlistboxname) <-changing the name to match your listbox name

Google is your friend! http://allenbrowne.com/func-12.html

Can you post an example or just type it in how you want it to look? Im still confused

Touche! I thought everyone had esp-n by now anyways. Have a good one and thanks

You are supposed to be able to read my mind! And I did state the problem in the very first line! I didn't say click a button! And i did create a blank one already, but it didn't keep the table closed when I created a new one. I thought that there might be a way to force it into design view...

Right I know that. But when I first open a database it automatically creates a table and its in datasheet view!~! Don't want it that way. Id rather have it not create a table at all!

Alright smarty! I'm talking about when I create a new table. I want it to open in design view automatically!!!!!!!!!!!!!!

You are asking it to get its value from itself! you need to base the customer ID off of something else... is this form based off of a query or is it an unbound form?

Is there a way, in access 2007 for the tables to automatically open in design view instead of datasheet view? I turned off "Enable Design Changes for tables in datasheet view" thinking that that would fix the problem, but now they open up in datasheet view with just the ID field and i still...

That's what i said! ;)

check this out if you are using a form, you can do it this way between [forms]![frmname].[startdate] AND [forms]![frmname].[enddate] if not you can do between [enter start date] and [enter end date] put that into the criteria for your date field Also for your form- you can do...

Happy to help

Whats your exact code behind the button?

You would want something like this employeepassword= DLookup("EmployeeUserPass", "tbl_Employee", "[EmployeeUserName]= """ & txtName & """") To get the user password See this thread on changing a users password. You should be able to use the code on there to make a login form...

Can you post that in code snippets or samples? I went looking for it and couldn't find it!

Use the search feature in the forum! It works wonders! Look at this post and see if it points you in the right direction http://www.access-programmers.co.uk/forums/showthread.php?t=187178&highlight=combobox+criteria