Search results

Hello All, I'd appreciate your input on how to set up my tables as I'm just starting off with setting my database up and I want to make sure I start off in the right direction. I'm doing a simple database to track the purchase orders (PO) I am managing. Each PO has a PO Number and an Original...

Hi Guys, I am trying to develop a database for my company to track the process / details of each project vs resources. Each project has 12 engineering roles. Engineers can do one or more role in each project. To make things more complicated engineers can work under different companies. I...

I created a FE/BE database, the FE runs very fast at out local office but extremely slow from our other office. Its around 300 miles away. I don't think its a bandwidth problem as when we send large files between the two sites its rocket fast. Note that the network between sites is an intranet...

Hi guys, With your help I have reached the final stages of my database design. The database is now aprox 6MB. Around 15 users will be using it (rarely at the same time) The database is in one mdb file and stored on a shared drive. Do you think its worth splitting it into a front/back end or...

Hi guys, I have a table: tblDeviceClasses ->Key ->Name ->Path ->DeviceClassForm In my main form, I have a listbox which looks up this table and shows a list of the names. The Key is the bound column and is hidden. I want to select one item from the list and when i click a button to open...

Hi Guys, I am not sure if this is the correct place to post this but here I go anyway. I want to automatically parse the username of the windows user and limit the functionality of the database accordingly. In fact, I want to hide/show a specific button in a form based on the user using the...

Hi guys, I have 22 forms and 22 queries. Each form has a subform which is based on the form's corresponding query. Instead of having 22 subforms can I have the same subform in all forms and populate it with the appropriate query? If yes, when would I populate it and how? Cheers, Christakis

Hi guys, I asked this question ages ago in a different thread but didn't get an answer. I am wondering if this is imposible or simply too difficult for people to bother and explain. When I open a form it is in window mode and exactly as I want it to be. How can I make it to auto-resize...

Hi all, Do the names of components (ie comboboxes) need to be unique in different forms or can they have the same name? The reaosn I am asking is that it would be great to just copy paste common fields in all forms. I know you can do it but will it cause any problems later on? Note that the...

Hi guys, I am creating a form with multiple tabs. However when I reached the form width it didnt create a second layer of tabs as I expected. Instead it added an arrow button to scroll to the tab I want. Is there a way to create multiple layer tabs like programs have? Cheers, Christakis

Quick Question, What does the data entry property in a form do? Cheers, Chris

Hi guys, I created a quick form using the wizard. I then cut/pasted all components in another form and I get a #Name? error. I deleted the wizard form completely so that the components are not duplicated. Combo-boxes row source works fine but the component still refuses to link to the table. I...

Hi Guys, I want to have 2 separate forms to add and edit records. How do I make sure there is no way a user can edit any records in the "add form"?! Here's what I've done so far: Removed Navigation Buttons Set "On Open" event of form to do the same function as a "New Record" button However...

Hi, Is 12MB normal for an Access 2003 database with 3 tables (30 fields each but no data in), 3 forms and 2 queries? Something is not right... Any ideas? Best Regards, Christakis

Hi guys, I have a table called, tblC1: ID [Autonumber] Type [Text, Lookup from Value List] etc each record has a type. So I would have Type 1, Type 2, Type 3 apprearing several times. In my "search" form I want to have a combo-box which will lookup what types are available and display...

Hi, I have a form with a few combo-boxes and a subform. The subform displays the results of a query based on the selection of the combo-boxes above. Each row of the query esentially is a record. I want to select the whole row (like a listbox) and use it to run a vba code using info from a...

Hi guys, I am trying to create a form which is split into two parts to filter the records of a table. The top part will have search fields and the bottom part will show the results of a query. I managed to create the query to filter assets based on the Preferred field of table "comAssets"...