Search results

I'm having trouble with a query that I'm trying to link to a combo box The query drives a list box. In theory whenever the user changes the combo box the query/list box will cange accordingly The line in the query that doesn't seem to work is: WHERE...

some of the other pc's don't have american dates set. Shot in the dark but worth a try.

I want to be able to create a form so that a user can dynamically change there login password without using the access defaults ie user types in their userid and there old password and then a new password. The new password is then written off to the mdw file. Is this possible.?

Now thats confused the problem more as i've never done this before but all the other databases work. I do have a system.mdw file in the winnt\system32 directoy. Surly though if you remove all the admin priviliges from the mdb file then it shouldn't load.

Have done it loads of times before but for some reason this one don't work Created a new user "harrisw" and a new group "supervisor" and put a password on it so the login prompt appears. Removed all the ticks from database, tables etc for both the admin and users groups and put ticks in all...

I have a statement Right(Format([tblJobs]![tobechargeddate],"mm"),2) which retuens a 2 chr month. How can I returnb the previous month in the same fashion I've tried Right(Format([tblJobs]![tobechargeddate],"mm"),2)-1 But this seems to return a 1 chr month, all be it correct I want to be...

sorted it. I was using a combo bow that had specific dates in that users must enter. What was happening however is that the key in the table was being put into the underlying table. Because the key isn't a date its just an integer it was causing problems. I've now got it so that the form...

Strange I know but can it be done I have a combo box with dates in it. The combo box is linked to a table for its values which are "short dates" in the format This value is then stored when the form is saved into another table again with the field set up as a short date. When I try and save...

Still not what I want to achieve. I have a form with a list box on it when the list box is double clicked the sales area that is clicked in the list box will form part of the recordset /sql statement and then diplay a query in table form on the screen. The user can then print/email/export to...

The sql bit is already driven from a list box which has the txtsalesarea in column 0 Is there a way that this can display after the user double clicks the list box.

Having trouble with trying to display the details inside a recordset I have the code below Set rsset = dbase.OpenRecordset("SELECT * FROM [qrySalesAreaList] WHERE [Sales Area] ='" & _ txtSalesArea & "'") The query works but I want to be able to diplay the results in a normal...

on the form load "Me.cmbQuery.RowSource = strList" gives an error saying the setting for this property is too long. Any ideas

Is there a way I can display the contents of the query tab in a drop down list on a form so a user can simply click one to run the query. Rather than them having to see the database window.?

I have a table of data. One of the fields is linked to another table so that a user drops a box down to select their entry. When the table is displayed in a list box using a wuery to get the matching data the drop down fields appear as numbers. Is there a way to fix it?

Anyone used the above? Are there any known issues that anyone can think of? Many Thanks

I've got an access 97 database ready for you. Still not got a PM with your email. Cheers

As the data is of a sensitive nature I can only send you the database with the 3 tables (without data) Can you pm me your email address?

Just tried the code but I keep getting "data type mismatch errors". All the fields in the tables are test if this helps. Thanks again

charityg Thanks for that, How would I change the SQL statement if I had a 3rd column in table 2 that said how many records I wanted to return? What would it do if the recordset didn't reach the number of records required.? Thanks Again

I have two tables. First table holds the data. Second table holds criteria ie activity of business, number of employees. Instead of having a query and changing the criteria in it manually to match the second table how can I do it so that it will read each line of the second table and query the...