Search results

I have built a Subform inside a regular form. I have a text box inside the subform. It it set up as Text in the table. When I go to enter in information I get this message: "You cant assign a value to this object" *The object may be a control on a read-only form. *The object may be on a form...

Is it possible to make a query's criteria pick data out for 2 seperate fields? For Example: Movie Database Field One: Actor 1 Field Two: Actor 2 Field Three: Movie Name I want to enter in a Name "Chris Farley" and have it sort Field one and two and list all the movies that contain Chris...

There is only: Option Compare Database at the top. I just now defaulted the Option Explicit on Access 2000. But for the database I programmed prior only has the one option. When Im in Visual, I cant seem to be able to enter in the line: Option Explicit

Hello, I did an Anaylsis of the Performance of my database and for all the Forms the suggestion is to put Option Explicit in the first line in the code. Ive only delved into code a couple times and could use some help on exactly how to enter the code into place. I did a search and it seems like...

I did a Analysis on my database. It churned out this huge list of suggestions. For all my Macros it suggestion coverting the Macros to Visual Basic Code. I tried on one of the Macros. And converted it. Now I have a module named what the macro was. Question is: Should I now delete the Macro...

Forum like this one that is dedicated toward Outlook?? Did some searches and can only find Non-English forums Thanks for any help.

Thanks for the replies and sticking with me on this. I took out the space and now I dont get the error box, but it wont let me in. "You do not have permission to view C:\Pedmic Quality Program\" Why would this be? Im set up as the Administrator. I do have a question about Joining Workgroups...

When the error message pops up, it gives the option to select "Ok" or "Help". Help doesnt do anything, but when I keep clicking "Ok" the database eventually opens up Normally with the password thing. Kinda stumped on why this is. I now moved the *.MDW file into the Database Directory on the...

Thanks that thread had a ton of great information. I cleared up my issue with the Search Key message. But now I have a couple of things to clear up. When the shortcut for the database was made this address is giving me a error. "The command line you used to open Access contains an option that...

But its not just when Im creating a macro, its happening when i go to build a query. The same exact message. Its not Access itself because I can go to another program and add a macro or query to them with no problems. Any insight on this would be appreciated. Thanks.

I just made my database "secure" with the User Level Security Wizard. I am listed in the Admins Group. Everything is working okay. I can access all the areas. But when I went to make a new macro and save it, I received this: "The search key was not found in any record." And I cant save the...

GOT IT! Gosh, that feels good. There were two fields named the same thing in my form and subform. The sort was to a Autonumber field when I was thinking it was going to another field. Sort works great! :)

Yes, I tried that. I only need to sort by one field and i have that one in the first box and then set to Ascending.

This is kinda a combo of a query and report question. I have a report built from a query that brings up four fields. I having trouble with the query to sort. I have the first field [Product Name] set to Ascending. But when I run the query it doesnt sort to any one field. I have to manually hit...

Voila!! Unconfused....I was putting the calculated field in the page footer, not the report footer. Works like a charm! Later

I just tried something. I put the text box with the calculation in the body of the report and it works perfectly, but then as you know, it shows up as many times there are entries. So thats the reason I want it in the footer, but when its there I get the #error. Confused... john

I have a report based on a query that calculates a figure for me. I want to take that figure and have a total at the bottom of the report. I put a field at the footer of the report and entered this in the control: =Sum([Cost]) Im getting the pesky #error on the report. Seems like a simple...

Im getting a date error when i try to enter a date in a subform "You cant assign a value to this object" 1. The object may be a control for a read only form 2. The object may be on a form that is in design mode 3. The value may be too large for this field. I have the table for this field set...

Worked great! Thanks

I have five text boxes that Im adding up. Some of them could be blank. Right now my formula is this: =[Text70]+[Text72]+[Text74]+[Text75]+[Text76] I need a Nz formula for this for the times a box is empty. I tried this but it doesnt work...