Recent content by skaas

Eventually I was hoping to expand the information on the tables. For example the workstation table would also hold information on the Workstations hardware. The mobo, cpu, ram type, whether it has a CD-Rom or Writer, etc. Printers table would hold info for compatible toners, etc. This way...

Greetings all, I am still a noob at Access and have now started learning to use Queries. I am still reading a lot and trying out some things. I could use some tips on solving a query, being the greenie I am ..... :confused: I have put together a simple Inventory database which all works...

General Here is a quick fix solution to your problem Please place the following code into your Forms Load area PrivateSub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load Me.ControlBox = False End Sub (Don't forget to change the...

Use some VBA code to prevent users from being able to close the form window... There are plenty of samples in archives that will allow you to do this. If you require access to more than one form - Consider merging the forms into a Tabulated format. Users would be able to browse the forms...

If I understand correct, the dates are entered automatically into the table? If so, how is this done? Do the dates come from another table? If the data is object active then it cannot be bound from the table it is being output to, you would need to create a relationship link to wherever the...

general Hi, Glad to hear you are making progress on your work 1. Here is a quick link expalining how to hide forms and other access modules from users http://www.techonthenet.com/access/database/hide_tables.php This quick link will explain how to make your data base show a form when a...

Would it be feasable to create a new table showing the date values? You should be able to to get your query to export the values into a new table that you could use purely for the purpose of creating the Look-Up

Are you wishing to show data from your table onto your form or Are you wishing to show data from your quiery onto your form?

You may also find this sample useful http://www.rogersaccesslibrary.com/Access2000Samples/ComboChoosesRecord2k.zip

This is because your combo boxes are not bound correctly Nothing to do with SQL I have provided you with a sample with many ways to get around this and the correct way to bind your combo boxes. I hope you find this useful...

Q1 You Should find this useful http://www.fontstuff.com/access/acctut03.htm Q2 Create a quiery to perform your dates calculations as above Then create a Look-Up queiry that will use the calculations queiry as its data source. Select from the calculations quiery to display completed...

Does it all work ? Or are you still having errors?

General Here are some viable options that may help put you on the right track I hope these little snippets help DCount counts the number of records that meet criteria specified in the criteria: DCount("FieldToCount","Table or Query Name","Criteria") Examples: The first example counts...

Do you wish to count the values directly from tables or from a pre-determined recordset?

Hi Thank you for your reply... The data itself is not being pulled from a quiery - It is being pulled from a Back-End database that the main users have no access to... The Form synchronises with the back end and transfers the data... The data is then displayed into text boxes on a...