Search results

private sub DisplayThis() Dim rs as recordset Dim sSQL as string Dim sVal as String txtInformation = "" sVal = "" sSQL = "" sSQL = sSQL & "SELECT * FROM tblTableName " sSQL = sSQL & "WHERE Name = '" & replace(cboName & "","'","''") & "' " set rs =...

Thank you to both RuralGuy and Wazz. That solved the problem. EZ

I was playing with some VBA to enable and disable all MS Acces default menu. Now my right click is no longer working (disabled). For example, I cannot right click on a form and choose properties. I am not sure how to turn the right click options back on. Please help me out. Thanks. -EZfriend

Couple options: 1. Put in a folder where authorized users can access 2. Create a table within the Access DB and make it a system table (MsysUser) so that the table doesn't display. In the table, you can authorized users and check against their login (Windows Current User) to see if the person...

I use to be able to resize the navigation bar ok, but a week ago it decided to lock itself. Other dbs appear to be fine.

How do you unlocked the navigation pane in MS Access 2007? For some reasons, I just can't unlock or resize the navigation bar. See attached picture for more info. Please help.

How do I open the printer printing preferences with the click of a button? The question seems easy enough, but I just could not find any good code for it nor come up with my own. Please help. Thanks. EZ

1. You can create a table to hold your employee information tblEmployee Employee_PK FirstName LastName HourlyRate UserName Password ..... tblTime Time_PK Employee_PK ShiftStart_DT LunchStart_DT LunchEnd_DT ShiftEnd_DT 2. Create a form for employee to log in. 3. Create another form with...

Private Sub Form_Load() 'lstField Row Source Type = Value List lstField.AddItem "001" lstField.AddItem "002" lstField.AddItem "003" lstField.AddItem "004" lstField.AddItem "005" End Sub Private Sub lstField_Click() Text2 = lstField.ItemData(lstField.ListIndex)...

May not be the best suggestion, but it's a suggestion. Create a field in your tblOrder. Let's say [TempOrder (True/False)] Let you user create as many orders as they want, but when user click on Commit Order, just turn that field to FALSE. If Cancel (or form closed), just clear everything...

Probably best to create a query that link all your table by the Cadet_ID and then carefully check your query JOIN to use LEFT JOIN on tables that do not always have a related record to the main table. Set the control source of the form to that query.

Use the code below to get your word document content and then you will need to play with the STRING functions to get what you want. You will need Microsoft Word XX.X Object Library Private Sub Command0_Click() Dim app As Word.Application Dim objDoc As Word.Document Dim sVal...

Does Access has the capability to create a form, let's say in the shape of a triagle? Besically, I want to hide the default form (box) and only show the section of a picture (PNG with transparent background) that's not transparent. Thanks in advance for your suggestion. EZ

Can you filter out the £0.00 in the where clause for the report control source or query?

Thanks for the suggestion, Boblarson. I'll give the Excel Object a try. I did some thing like that a while back with excel object so this should be easy to just get back to it. The thing that questions me is that why some of the totals get exported fine, but not all. It must be a...

I have a report that the Report Footer section display a total of some document counts; however, when export to excel file, only some of the data were exported and some are missing. The settings for all of the controls in the Report Footer section are the same with the exception of the...

You can create that as a public function and stored in a module. The function can be called from a query or a form (button click event, likely). You will need to decide what parameters to be passed to the function and then return the appropriate result. For your fees, you can probably create...

Problem solved. Import into a different file and that seem to go away.

I have an application that uses the ListView Control 6.0. The click event check for the number of list items in the listview. If the item counts is greater then zero than it calls a sub routine to check for the ID in the database based on the item selected. I keep getting the error below when...

If you provide more details on your project, I can certainly take a look and help you out.