Search results

I think I have this one cleared up. When I create the combo box I select the field header that I want to use. Example - REPORT When I go into the properties afterwards it shows my field source as follows. [REPORT].ID I have no clue as to how this happened but when I change it back...

Thanks for your answer Casey. I only have one column in the combo box. I tried changing it to a list box and I am getting the same results. It works the first time and then when I try to change the size, test, etc of it, I go back to the form and it shows the record number. This is not the...

I added a Combo box to one of my forms that selects a record in my table based on a particular field. I save my changes and open the form and it works fine. I select from the field and it goes to the record. After this I go back to my form in design view and change the size and text for the...

Work group file Thanks for all the help. I created the shortcut and it works great.

Work group file What if my security is being handled at the network level? I did not create all these users in the database but instead gave permissions within Novell. What happens is when a user who did not join the workgroup file enters the database, he is allowed to go from switchboard to...

Is there any way that I can add users to the work group file (.MDW) so they would not be required to join it?

Can anyone tell me if this is possible. I created a data access page to link to my data base from our Intranet. I am able to see and manipulate the data without any problems. What I would like to do is be able to request a report or run a query. I tried doing this with a command button but it...

Good morning all, I am importing a table from an SQL data base using an ODBC data source. Every time I import this table it creates a new table in my Access database (Access 2000) with '1' at the end. I then have to delete the old one and rename the new. I would like to be able to replace the...

Access Security Hi Folks, I have been following this thread as I have the identical problem with a new database I created recently. (My first) Am I safe in assuming that since the system.mdw file and the database reside in the same folder on my server, renaming the .mdw file will block other...

Same query, multi[ple forms Thanks Chris, I'll give this a shot. Should save me a lot of work and confusion.

Good morning, I have a query in my database that can be accessed from multiple forms. I am using the date and time picker to feed the date range to the query. The date and time picker is on the form and the form must be open for this to work. On the criteria line of my query I point to the...

Calendar I got it working Jack. Your instructions were right on the target. The problem was my expectation of how it would work. I thought I would be able to access the calendar from the unbound field but in trying differnet things I found that the date is entered into the field from the...

I have just finished setting up security on my database. There are two issues I am not crazy about. The first is that any users in the network who are not part of the Access workgroup that I set up can get into the database (Which resides on a server for now) and have all rights. I removed...

I'll take another look at all of this and let you know how it went. Thanks again for all your help up to this point.

There are no parameters for the query. I created a new query and double checked everything. When I try to run the query using the command button, it opens up the query without asking for date parameters and returns no results.

Thanks for the help Jack. I did what you sugested but when I try to run the query it still wants me to manually enter the dates. Perhaps you can be a bit more specific when you metnion the unbound fields. I used a text box from the tool box to create these fields. Will that work?

I have a query that requires a date range. Right now it prompts for the from date, I enter it and click o.k., then it prompts for the to date. I want to be able to use the date and time picker (Calendar) and have this pop up for the users to be able to enter the dates. I was able to get the...

I set up security on my data abase using the wizard and everything seemed to go fine. The database resides on a novell server and I set up the security while working from my desktop. When I open the database from my desktop I am prompted to enter my userid and password but anyone else that...