Search results

I dont have a solution to your problem..but I have seen what you are talking about..normally in such fields I could use "Control + ENTER" instead of ENTER key..it works as a line break..

(I posted the same question under Crystal reports - but I wasn't sure if that is the right forum for this quetion...) Hi all.. I have created some crystal reports that I want to distribute to the users. The users do not have crystal reports on their computer. I want to package the crystal...

Hi all.. I have created some crystal reports that I want to distribute to the users. The users do not have crystal reports on their computer. I want to package the crystal reports in the access application and package it. Access application will have a list box with all the reports and user...

Forgot to mention this. I am getting 'object variable block variable not set' error..

I am trying to print reports based on a particular field value..I am not sure how I can do this...But tried the following code(if you can call it code)..I am really new to access and reports.. if the value is 1 then I want to print the report JOB which I created using the wizard..except that I...

Is there a way to disable ESC key... I am just curious if at all there is a way to disable ESC key. My problem is I have a messagebox with OK and CANCEL button...When the user hits ESC...the msgbox disappears but when I execute the code that displays the msgbox again, it will not come up. I...

Andrew..thanks for the link.. But I am not getting what I want...I followed the steps to create a menu. Then when entered the menu name in the Menu Bar property I am getting the msg "The custom toobar <menu name> is the wrong type (menu, shortcut menu or toolbar) for the property it is being...

I could not find Menu design in Access...Is it available during design time? When I searched for it I found AddMenuItem to programatically add menu... I vaguely remember seeing menu design in VB 3.0 7 years ago...I am looking for something similiar.. This probably the simplest and stupidest...

Hello.. I have the following code. This code works fine in my computer..but getting subscript out of range message in another.. Mine is 2003 and the other machine is 2002. I am not sure if this makes any difference! GetRows may return anywhere between 0 - 5 rows. Please help! UserLinks =...

Any help? Anyone experienced this problem? I have added reference to "Windows Script Host Object Model" but still problem exists.. Thanks

Hello.. I got the following code from this forum to create shortcut on the desktop.. ================== Set objShell = New WSHShell Set objShortcut = objShell.CreateShortcut(objShell.SpecialFolders("AllUsersDesktop") & "\" & sShortcut) objShortcut.TargetPath = sDB...

Thanks guys..DoCmd.Maximize and restore worked. But when I tried removing the acDialog, the report was opened behind my current window also in the same minimized size.. Thanks again..

Hello.. Only few hours ago I created my first report in access(2003), so my question most likely is very stupid.. I found the sample code somewhere and modified a little bit... I have a list box that displays the report names and when I double click I want to view the report.. See my code...

I am getting Compile Error User defined type not defined.

Hello... This should be an easy one for many of you.. I have the following to code to let the user select a file.. It worked before but suddenly stopped working...I remember adding some reference but I dont remember exactly the name of the reference.. After I did this, I converted the...

Thanks guys.. I finally got the security working.

ghudson... I am not sure how old this post is..I was looking for some advice on where to copy the FE and BE and I found your post. Can you please tell me the database name in the shortcut "\\Server\Partition\Directory\DatabaseFile.mdb" is front end or backend ? Can I assume that this is...

Andy.. Finally I ran the USER-LEVEL security wizard (Access 2003). After it is complete, I see the owner is changed to <Unknown>. I dont know how to interpret that.. But then I get error msg that I dont have access to my backend. I ran the security wizard on my front end..I have a separate...

Hello.. I have followed the instructions in the Access Security FAQ..after running the security wizard..I am getting an error msg that says I dont have access to my backend.. I have my front end and backend databases separately..I ran the security wizard on my front end..How the backend knows...

Andy..thanks for the response.. I could only find "user leve security wizard" under Tools> Security> I tried it (but I canceled after several steps without finishing it)..but it seems to create users and groups with different permissions... Its not doing anything for ownership change. I only...