Search results

I have a form with a field that I have SQL in for the record source. However, when the form opens the field is displaying the table that is used in the query. ie, the fields are in order of the table not the query. When I put the form in design mode and click into that field and run the query...

I want the values of the constants. I want the values of the constants, ie, vbKeyDown = 13.

Does anyone have a list of the keycode values, ie, Keydown is 13, keyup is ??? Thanks in advance.

I have a mainform with a "Type" field. The subform is linked to the mainform by the vendor name and the type field. I want to change the type field on the main form. When the user changes the type field the subform goes to a blank record. I know why this is acting this way , it's because of...

using mid function to extract date How do I extract a date from a string using the mid function when I don't know the length of the date field, ie, it could be 2/1/03 (6 long) or 12/23/03 (8 long)? The date will be starting in the same spot in the string I just want to replace it with the next...

Now, how do I gracefully close the design view? I now know how to open the report in design view, change the groupings, but after the report opens up in Preview and the user closes it, what is seen is the report in design view. Of course, I don't want the user to see this. Pat, you must have...

What about OpenReport? Does that allow design view? The report is where I need to make a change that will only allow it in design view. This is not multi-user, so that won't be an issue. Thanks!

I have to change the report sorts in code depending on what the user selects on the selection form. I also need to change the group footers by using the CreateGroupLevel method. I can't use this unless the report is in design view. Is there a way to change the report to design view in code...

Here's what I mean by change criteria My query now has for criteria the following: WHERE (((ISTSelectedDepartmentCodes.[Selected?])=True)) OR (((ISTSelectedDepartmentCodes.DeptCode) Is Null)) For some instances I need the query to leave off the stmt after the OR (just do up to the "=True")...

Is it possible to change criteria in a query during runtime? Based on what the user asks for I have to do this. Thanks in advance.

I have a form with a subform. They are related by an item number. I have a button on the main form that on_click it goes to a new record. My subform info doesn't appear, I presume because I am going to a new record and the item number is blank so the subform has no info. My question is: How...

Is there a way to set an access2000 db so only one person can edit the db at a time? I went into Tools,Options, Advanced and see there is a Shared/Exclusive option, but I heard that sets all of your databases to what you select here. Thanks in advance for any help.

Thanks, Jay. I was beginning to figure out that I couldn't compact in the same database.

How do I compact my backend database from within my front end? When I run the code in the module it works. When I log into my front-end program and click on the button that runs the compact code I get the message that someone is using the database and can't compact it now. Help!! Thanks in...

I need the code to check if the backend database is in use. Anyone have it? Thanks in advance for your help!

What is the VB code to make a copy of an access database? Thanks in advance for any help.

I know how to use the alter statement in a data definition query to add a field to a table. How do I make that field (it is yes/no) display as a checkbox? my code is: ALTER TABLE ISTtbl_PRProject ADD COLUMN Selected yesno; This adds the field properly but doesn't display as a checkbox...

Is there a default setting or something I need to change in my access software that allows the linked table manager to link all tables at once when they come from the same database. I select all for linking, then it prompts me for one at a time. Any help is appreciated.

Is there a way I can have the record source for a form one table, but have another table updated too? Thanks.

I am using the built in find function on my forms. The user searches a field with this, finds the record and goes to the form that displays the record, makes a change, then when he goes back to use the find command gets a message that it's not working. There is a menu form that is staying open...