Search results

Hi all, Oh yes..that's all I need ghudson! Now everything is working fine as I desire! I set up the user-level security, disable toolbars at startup for anyone other than administrator...that's it!! Oh.. also thanks to Ricky Hicks as your codes on this forum enlightened me on how to...

Hi Pat and all, Thanks for your reply. Now the problem is how do I remove all toolbars? I'm using swithboard to navigate among forms currently. Does it involve the startup property setting? or in more specific what else need to be done? Bello

ghudson, Thanks for putting me on the right track!

Hi all, How can I prevent users from printing and/or exporting confidential table data unless they do so through the form provided? I need this for security purpose so that in this way I can trace and record every actions (exporting data etc.) done by the users. Any advises would be highly...

Hi Chris, I changed the where portion. Please try this one: sql = "Update tblDesignUserRequirements " & _ "Set [tblDesignUserRequirements].[SectionID] = " & Me.[lstSectionID] & _ " Where [Index] = " & Chr(34) & Me.[lstRequirements].ItemData(ItemIndex) & Chr(34) & ";" Hope it works. Bello

Hi Robert, I Honestly do not know how to accomplish that through VBA, but do found a way to help you. 1) Open a new Excel file 2) On the menu bar select 'Data' -> 'Import External Data' -> 'Import Data' 3) Follow the instruction on the screen to import your result Excel file (the one you...

Hi Calv, The problem lies on your listbox -- an listbox item can ONLY holds up to 255 characters. According to Access specification, textboxes can holds maximumly 65,535 characters. You were trying to assign the textbox value from a listbox item, that's why it got you only the first 255...

Hi Chris, I thought you can't include an item from multi-select listbox into SQL statement just like that. Your code should rather looks like this: ------------------------------------------------------------------- Dim ItemIndex as Variant For Each ItemIndex In lstRequirements.ItemsSelected...

Hi Jack, Thanks for your help. I've got the problem solved.

Hi all, For a form with record source set to a table, how do we order the records by their entering sequence? In other words, I want the latest added record to be displayed when I click the 'last record' navigation button. I'm not sure but seems Access will automatically sort the records...

Hi Milan, What I would do is - in the design view leave the Row Source property of your listbox blank. In the OnClick event of your make table button, set the row source property to whatever you need right below your make table codes. May as well set row source in form_load event so that the...

Hi RichardJ, Thanks for your reply. Yeah, use double quote or chr(34) does solve the problem when your parameter value contains only the single quote. But the point is, there is a conflict between the quotes that you use to represent a string and the quotes that actually are parts of your...

Hi all, There are some situations where we need to take a control value as parameter for searching. Consider this example: ------------------------------------------------------------------------------ Mytarget = "[MyField] = ' " & MyTextBox & " ' " If IsNull(DLookup("[MyField]"...

Rachael, Try this: DoCmd.RunSQL "DROP TABLE YourTableName" Regards, Bello

Jaydwest, I wonder if this is a better way... 1) Create a recordset. 2) Includes following criteria as your record source. 3) Replace 'YourInvoice' with a control value or any invoice no. 4) The very first record in recordset would give you the answer...

That's ok Calvin. I know you were trying to help me out...Thanks anyway.

Calvin, Exactly. I want to make a listbox item NOT selectable and in some conditions make it selectable again. I know it can be done in Foxpro by leading your item value with an '\'. But seems it doesn't works the same for Access...

Hi all, I thought Access does not allow us to modify an item in listbox. However, does anyone know the way to disable and re-enable an item in listbox? Thanks in advance for any advises!

EMP, I'm using Access 2002. However, I just figured it out that the 'listindex' property did the job!

Tim, Thanks for your reply. But I afraid what you suggested is only works for single-select listbox as the 'selected' property doesn't move the focus for a multi-select listbox...