Search results

Sorry my bad, you need to change column count field in properties for the user combo box from 1 to 3 and hey presto, it will work

Can you just post what you put in the control for location

Ok, this should do it Step one Change the row source for the user combo to: SELECT User.User, User.Department, User.Location FROM [User]; Step two Change Department and Location to text boxes Step three Source for Department should be "=Me.User.Column(1)" Source for Location should be...

Can you post a copy of your database on here? Then we can have a look at it.

Or CurrentDb

Are all the users on the same network? If so, go down the front end/back end system. Its easier to control and manage

Can you not use front ends and have a single back end to store all your data?

Or you could do the following, not sure which way would be best for you though. Customer Table Cust_ID {pk} etc ... Product Table Prod_ID {pk} Prod_Price etc ... Price Table Prod_ID {pk} Cust_ID {pk} Sale_Markup That way you would only ever have a single price for a product for a particular...

Sounds a bit like a 3 way Many to Many relationship. The only way I can think of doing it is the following: Team Table Periods Table (as in a period is between Date A and Date B) Rosters Table Then you would have a table in the middle of them all, with each record storing a Team, Period and...

If you can write the conditional statement, try having a look at TableDefs Will need CreateTableDef, TableDefs.Connect, TableDefs.SourceTableName and Database.TableDefs.Append To delete the connection at the end of a session, you will need to use DoCmd.DeleteObject

Is the form maximise? If so, they could be the access application buttons rather than the form. If so, you should leave them there. If the form is not maximised, I'm extremely surprised. What version of access are you using?

Yes you can. In design view of each form, look at the form properties, under format there is "Min Max Buttons" and "Close Button", set these to None/No and hey presto they disappear! :)

Ok, not trying to teach you how to suck eggs, but does the database disconnect itself from the tables each time, or do you have a load of linked tables in your database? If so, delete them and hopefully problem solved. If not, let me know and I will give you my email and I will have a look at it...

What version of access is it?

Thanks Bodisathva. So effectively I would be creating a module on the fly each time ..... Ok, gonna need to go have a read and play. Thanks for pointing me in the right direction

Another way is to create queries on the fly using SQL statements, refering to them to each other as required. Once you have done that, you can (as Moniker says) use docmd.sendobjects or docmd.transferspreadsheet. Suggest that you would output the data you want to a temporary table, format it...

Thanks Thanks for that Rabbie, unfortunately, this is one of the few occasions I am not using a query. Mainly because I am only reading from the data through DAO from VBA. My problem is changing an array into a set of variables, if I can do that I will be well away and extremely happy. The...

I'm trying to create a filtering system for a customer of mine, based upon a series of SQL strings. I've created a table with all the SQL, etc in, but part of the problem is that I have variables amongst some of the SQL statements. I can pre-define the variables along side the SQL in the table...