Search results

I have a listbox on ny form the user selects a topic fron the listbox and clciks a button which opens a form with the details of that topic, that works fine. But if the user clicks the button before highlighting a topic from the list it opens a blank record. Is there a piece of vb code that...

I have a button on a form which is attached to a query when the query runs it puts the results into the listbox, if the query is nil I would like to have a msgbox say no records found. I need the vb code to check if there is anything in the listbox and if not run the msgbox, I beleive this can...

I have tried both suggestions above but,if you put rowsource="" it clears the query altogehter and then does not work. The second idea removes what I selected. What I wanted was to clear the result of the query from the list box so the user can select a new subject and the query result shown in...

Thanks alot that worked

Is there a code to empty a listbox, I have two listboxes when a user selects from one listbox it runs a query and puts the result into another. If they want to select again, I have to close and then open the form to clear the listboxes. I found some code but that clears the highlighted item...

Part of my database that I am building has a section for contacts, on a search form I have a list box where is attached to a query, the listbox shows Firstname,Lastname,Telno. As there will be over hundred contacts in the database I want to be able to have buttons on the form where the user can...

I am pretty new to vb codes, but I was trying to use the Boolean variable. I have a main menu where users can select to search,edit or delete reocrds. If they click the edit or delete button they go to a search form when they have found the record from a list they click the search button which...

I am in the process of building a database for the company I work for, they then want to sell it to the clients. I made the database into MDE database, this protects the forms and vb code but not the queries. I know I can password the whole database but if the queries where written in vb they...

1..If there is no data for my report, my msgbox will come "no record found" the next command I put in was Canel = false. My msgbox comes up ok put when you press OK access produces another msgbox saying event cancelled. I have tried putting the code I am having problems with the command...

I have build a database which contain several queries that I have designed using access. I would like to be able to write these queries in vb code instead, does anybody know of examples on how to write them, or any websites that would teach me.

Can anybody show me how to setup a global variable. I have a logon form the security level needs to be the varible. How do you write a query which will check the global variablr against a record that has a security level. i.e if they match open the record if not Msg "no access" I have asked...

I am building a database for a small IT company so they can enter records for tip and tricks on how to fix things. They enter a record by selecting a Category,Subject,Topic then enter the details.I have build a search form so they can lookup any record. They want to be able to have a tickbox on...

What is the common dialog control and what are APIs

I made a macro and used the "sendto" option to send reports by e-mail, but it keeps telling me that can not send the e-mail and tells me to check that my Outlook is open. My Outlook is open any ideas why

I made a macro and used the "sendto" option to send reports by e-mail, but it keeps telling me that can not send the e-mail and tells me to check that my Outlook is open. My Outlook is open any ideas why

Is they a way to have a command button where it will save reports into text or Word. So when a user clicks on the button it will bring up the "Save In" box but the file name and format will have already been inserted

I have build a personnel database, on the form where the user enters a new record is there a way to put a link to documents relating to them. abit like the shortcut command and have the record save the links.

I have a form with several combo boxes on where users can select items. I put a button next to each combo box which when clicked opens a new form where they add items to the list. Is there a easy way to get the form that is open to refresh the list on the main form when it closese. I have tried...

I am trying to attach a query to a report so the report will show all the holidays taken by staff for the current year. I need the query to show the records from 31st December last year to 31st December this year. I can not find a way to put the month of december in a query with the current...

Where do I find the "solutions" sample database