Search results

I have a listbox that displays data according to a selection from a combobox. Now I want the user to be able to make a selection in the listbox and then a subform filters it's records accordingly. Suggestions? This is what i wrote, but it is obviously wrong. Private Sub lstResults_Click() On...

I have 5 columns MIndex - autonumber SIndex - number (long int) MOrder - number (long int) Month - Text Job Hrs -number (double) if that helps

why does it tell me i have a type mismatch?

I want to loop through the items of a listbox in my form and add the values from a certain column in the listbox to be displayed in a field on the form. How do I do this? This must be a silly question. This is what I have. Private Sub Hrs_Calc() Dim i As Integer Dim JHrs As Double...

I was wondering if anyone could give me some suggestions on how to design a database for a timesheet. I want to each employee to select from of list of standard jobs and enter their hours for each day in each month. Jobs can span months. in the end i would like to view hours spent by everyone...

I have a preview button in my form that opens the report prevew of that form. How do I have the report preveiw open such that it is in front of the my form? Is this b/c my form is a popup?

I have an existing group. how do I add an additional toggle button? You would think just cut & paste or creating a new button and placing it w/in the group would work, but it doesn't! It is just a std button that doesn't give let me give it an option value.

I have a form with a print button that I want to use to instantly print the relative report w/o going to the preview first and then requiring you to hit print again. Is this possible?

i'm only using one event OnLoad

Dim Title, Message Title = "Creating a Mail List" Message = "Please select customer records for mail out." MsgBox Message, vbInformation, Title This is all I've done. What is the difference b/w using OnLoad and OnOpen? It doesn't effect my messagebox though.

thanks i figured it out already!

How do I print the current form displayed? I can't pre-choose this and use a query b/c it depends on what record is being viewed.

Well I was able to find some information on fixing this problem. However, since I had not done much work on the form&module I just deleted it. Now everytime I try to cut & paste and use that same form name it screws up and is not visible and goes somewhere I don't know. I don't have a problem...

What does it mean when you get a msg like this? "Error accessing file. Network connection may have been lost." What happen is I copied a form naming it differently, but they are exactly the same. Now it's completely screwed up. Anyway to fix it?

it is in the OnLoad event if that helps

I have a message box that pops up when my form loads up. For some reason it used to open the form first then show the message box, but now the msgbox pops up first. Is there a way to switch this?

does this piece of code make sense to anyone? Me!lstResults.RowSource = "ORDER BY Files!Proposal DESC" I have a button that is supposed to sort the values in the list, but it doesn't seem to work.

does this piece of code make sense to anyone? Me!lstResults.RowSource = "ORDER BY Files!Proposal DESC" I have a button that is supposed to sort the values in the list, but it doesn't seem to work.

Am I doing this right? I'm trying to call up a function in another funtion but I keep getting the error "Procedure declaration does not match description of event or procedure having the same name" ComboSort_AfterUpdate (Files![Mill Location]) I think that i am not declaring my variable...

I split my database in 2 (one forms, one tables) and now it runs really slow. I noticed that all my relationships were deleted and had to add them back in in the tables db, but it still runs slow.