Search results

Hi, "Admin" is what you open Access as by default (using system workgroup). For information relating to Access workgroups and security please search the forum. If you declare the username as a public variable you may have problems if someone else opens the database and changes the value of the...

Hi Guys, The asset managment system I have been developing is due to go live next week and I am really struggling with the data entry and search forms. I have attached a picture of the main form (and outlined each subform) to give you an idea of my project. The attached form is actually a Main...

Hi guys, Just want to check to see if a text file exists. If it does, then open it. If it doesnt, display a message. Have written the following code. Wondered how I can use the FileSystemObject to actually open the text file rather than using the Application.FollowHyperlink. Still learning VBA...

Try This.... Hi, The following would work. May not be the best solution but can't think of anything else. I presume your list box is based on a query of the table containing the yes/no field? I will presume you have three fields in your query: Project ID, Project Name, Yes/No. Add a button...

Cracked it!!! :) Think ive just found the solution. Using Pat's good advice I based my form on a query that contained the Manufacturer and Model Group tables, linked by the Model ID stored in the Asset Table. This meant that by placing the Manufacturer and Model Group Text Boxes over the...

Works okay... Hi Pat, Thanks for your post. Problem was that my form was based on the underlying table not a query. I have reposted my database after doing what you suggested. This works fine when viewing records. However, when entering a new record the combo the text boxes do not update with...

Example DB Please find attached an example DB demonstrating the problem. You can see that the records already entered do not appear to have anything entered in the Model field. However if you look in the TblAsset table you can see these values. The value will only show if the unbound combos...

Hi guys, I need to finish the Asset Management System I have been creating today. The main Asset Form works fine for Data Entry. However when I view existing records, the Model of the Asset (I.T Equipment) appears blank. The reason for this is: I have three tables linked in the following way...

Use a ListBox I would suggest you add a list box to your main form. Use the SQL from your current search query and add it to the rowsource of the listbox. Make sure that the bound column of your list box is the ID you wish to use to filter the form that opens. Add the following code to the...

Hi, Would suggest that you use the Wizard for this. Insert a new list box and select either: "I will type in the values I want" - enter your numeric values here or "I want the list box to lookup the values....." - find the table and numeric field you wish to use as the record source for your...

Thanks Pat, will give that a go. One question....I can see how this would work for the fields stored in my table. However as only software package edition is stored and not manufacturer/package name, how would I be able to show this data? Would I need a reverse lookup on the package edition? -...

Think ive cracked it....please see db attachment Hey guys, Think ive done it. Would it be possible for someone to look at my attached database. Ive created FrmAssetMain form with the Software form as a subform. When you click the "Add" button on the subform it inserts the values from the...

thanks for the reply. not quite what I would like to achieve though. I will not be opening the form separately so no need for the openform and link criteria. Just really need to know how I can insert a record into a database table without having to set the record source of the particular form...

Hi guys. I hope someone replies to this thread....I am struggling with this one. I am developing an Asset Management System for our IT Equipment. We wish to record the software installed on each PC. The Manufacturer and Software names are stored in separate tables. The AssetMain table has a...

Hi guys....im really quite stuck now. Original Problem: Cascading Combos on continuous forms. Changing value of combos changes all combos on form (although underlying data is not changed) Original Solution: Created unbound combo boxes on form header. Used the following code to add a new record...

I have three tables with relationships as below (where > is "one to many"): Manufacturer > Model Group > Model. I have a table called Asset. The Asset table has a field named Model On the AssetEntry Form the Model Field is a combo box that gets its values from the Model table but is filtered...

Would mean I am storing the data twice.....thats the problem. Implications of storing two additional long integer values in each record (say 1000) records, how much more space will I use? If it gets too complicated I may just have a pop up form that allows the user to filter the software and...

afraid not...its the continous forms that are causing the problem Thanks anyway

zoom... ghudson, Audit trail looks great, think I will integrate it into my current project :) I am trying to use a similar zoom function to what you have used to show a memo field. I tried using your code: Private Sub Event_Details_DblClick(Cancel As Integer) On Error GoTo...

Hi Guys, I have two unbound cascading combo boxes on a form that limit the data for a stored field. I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my...