Thank you for your help. I have figured it out!
James
dafinder
Last Activity: Jul 31 '07, 11:05 PM
Joined: Jun 5 '07
Location:
-
Building a Form
ACCESS 2003 NOOB
Hello all,
I can not seem to figure this out. I need to build a form that allows the user to select a range of dates, times, and protocols from a master table. However, when I try to use the fields in the master table in the form, the values repeat themselves in the list box (i.e the date 4/1/2007 is displayed over 100 times in the list box). How can I build a list box that only displays one value... -
Thank you for your assistance.
JamesLeave a comment:
-
Thank you mmccarthy,
To reply to that, I am a complete novice when it comes to access2003. What would be the best way to structure this query? I currently have the list boxes displaying their values based off of 3 separate queries. When i try to create a query in the Wizard with the three fields i want from the form, Access gives me an error. Any help will be greatly appreciated. Thank you.
James...Leave a comment:
-
We (my office) are going to migrate the database to an MS-SQL server database, so we shouldnt have any problems. On a related note, are the forms that are made in access2003 going to transfer to an MS-SQL database? Am I wasting my time trying to build a front end form in Access 2003 if it will be migrated to an MS-SQL Server?
Thanks for your time,
JamesLeave a comment:
-
Creating a button to make a PivotGraph
Hello All,
I am having a bear of a time with access2003. I am trying to build a form with a button that creates a pivotgraph off of the data selected in the list boxes of the form. Is there a way to do this? Thank you so much.
James -
I have over 50 gigs of space available. I have set the TEMP folder to C:\Temp
Any other suggestions?
Thanks
JamesLeave a comment:
-
I have set it back down, and i am still getting the TEMP File size error. Any other suggestions??
Thanks
James...Leave a comment:
-
We have solved this problem in office, but now have another one.... :-(
Thank you for the help.
JamesLeave a comment:
-
MaxLocksPerFile Error
I am running the table analyzer in access 2003. I have edited the maxlocksperfile entry to 300,000 and when i try and analyze the table i get a Not enough space on temporary disk error. I have a 3ghz processor and 1 gb of RAM and nothing in the TEMP directory. The database is over 90,000 records, but with such a large amount of ram and processor power, i dont think there should be a problem. What do I do from here?
James -
Thank you, my mistake.
James...Leave a comment:
-
Building a Complex form with many tables
Hello all,
I am a new user of Access and have run into some problems. I am building an access form that uses multiple tables. This is what I want to do in lay mans terms. I have a form with 3 sets of combo boxes. The first box I want the user to select a protocol that they wish to display.Next I have 2 combo boxes that display dates.
I have 3 tables, one with the date ranges, one with the protocols and one with all the... -
Thank you jl2886. I have had someone in my office help me out. Thanks again.
JamesLeave a comment:
-
I am using a filter form in the design viewLeave a comment:
-
User Defined Date Range
Hello All,
I have built an Access 2003 form that i need some help with. I have a user defined date criteria. I need to be able enter another criteria for date and have access show the range of records in between these two dates. When I tried using the >=# string it would display all records after the first user date entered. How can i do this? Thanks so much
James
No activity results to display
Leave a comment: