Search results

Hello, I have followed the very informative postings here on security and deploying a multi user access application and have started doing that myself. A lot has worked but there are a few things that are not working out right and I just wanted to get some clarification on that. Hopefully this...

Rural Guy, thanks for the suggestion. I will try and see if it works okay in other versions and if not try out the Late Binding.

Hello, I have designed a bunch of forms that the user will access through the Switchboard. Things are working fine except that when I deployed the application to a different machine from mine, the forms appear to not display properly in the sense that they are appearing too big and the user...

Hello, I have two questions related to deplying an Access project I have been working on. 1. I started developing the project in Access 2000, but midway upgraded to Office 2003 and so the remainder of the project has been developed in Access 2003. Things seem to be fine, except that in the top...

Ruralguy, thanks a lot for your looking into this and taking the initiative to offer an alternative solution. I will try this out and let you know how it worked.

thanks for the response RuralGuy. I have 4 layer deep subforms. Can you please elaborate a bit more on how I may tweak the code. I see that the code requires a subform name parameter to be passed for the calendar to show in a subform. Can you just highlight the main steps. I am a novice at...

"modify the code " :-( Now just how deep is the modification required, you think? this will be bummer if I cannot use it since I like the control, but then I have nested subforms several layers deep. thanks

any help on this please?

did not do that. Just did that and it works great! thanks. btw, does this work in a subform if the subform is within a subform. (the posting mentions it works only 1 layer deep. just wanted to confirm). thanks

Yes, I set the OnClick of the command button to =opencalendar("","text11") since my text box is not text0 but text11. Nothing happens with this. (i do not know whether this is relevant, but just to let you know that I also have another MS Calendar control on this form am trying out with...

I tried the simple Pop up calendar that ghudson suggested. I created the same module as in the sample form that comes with calendar and did the settings for the On Click aand OnDoubleClick as suggested. However, a calendar does not pop up when I click on the button or doubleclick on the date...

that helps. thanks very much

confirmation about automatic entry of the current date thanks a lot. but I have a question. Based on the Now() function, will this field not be updated everytime the user does something with that recrd. Meaning, if I create the record today, I understand that this function will insert the...

Hello, I have a quick question on how to enter the current date in a record automatically when the record is created. Here is the situation. Say I have a Products table that lists the products that have come into the inventory. There is a field that denotes the day the product was introduced...

I have a basic question. I am trying to put a button on a form I have created so that I can use Filter by Form feature on it. I used the toolbox commnad button wizard and chose the Form Operations -> Apply Form Filter option for the button. Unfortunately, this button does not work for this...

many to many relationship setup Base your subform on the linker table (i.e. choose the two id fields of the other tables from the linker table). then create combo or whatever control you want and base it on (i.e. choose id and desc etc field) the other table (not one on which you created the...

Here is my problem: Say I have a products table: PRODUCT ======== Prod_id Prod_name Dept Type : It is now possible that some of the products can also be a product group, and a product group would then consist of multiple products. (Note: if a product is a product group as well, both of them...

M-M tables and their access through forms I too have the same question. Here is my specific problem. Any help/guidance much appreciated. Lets say I have three tables in a M-M relationship. PRODUCTS ======== Prod_id Prod_desc xx yy : DIVISION ======== Div_id Div_name Div_lead PROD_DIV...

Good point. Currently, the job is done is an ~50 column Excel spreadsheet. The user takes each row (which is a product) and puts in information painfully for the 50 fields for that row and then goes on to the next one. When information for a product and any of its field/s is updated, the user...

Hello, I have a couple of elementar level questions on Form creation process and standards invloving a schema with several M-M relationships. I have a highly normalized design (thereby producing several junction tables). I have attached a picture of my schema to give an ideal of the schema I am...