Recent content by MsPeppa

If I was to read in 7 integers and I wanted to find the largest number using only if statements (no arrays) but also keep the amount of code to a reasonable amount, does anyone know how to do that?

That seems like it would work but not for this. My search opens a query, so I really don't have a form, it's only a query that is opened and depending on what the user searches for, that is how many records will appear so the number of matching criteria records changes all the time. Thanks

I have a DB that is very complex. I have 3 tables. The first table only has "Date" in it (current date) the second table has "Shifts" (employee work shift (1, 2, 3 etc..) and my last table is "Extras" (includes Event, Appearance, First Name, Last etc...) The...

I have a query that the user enters a start date and an end date. What I want to do is add a field so that there is a running total of how many records are listed. So like next to each record there is a number in that row. (i.e.) 1 Lucy Liu 2 Xena ...and so on, and let's say the...

I need to create an automatic generated number. The number is for field "Filenumber" and the format is "WMB2002-" then four numbers i.e. "WMB2002-0001" is there anyway to do this, so that once a user does "WMB2002-0001" the next record wil lbe...

I did what was suggested and I am still getting that same error. I do Not understand it at all!!!!.... Here is the piece of my code again, I put the close statements at the top. It just doesn't make sense why it keeps on giving me that "You canceled the previous operation" at the...

I have a form that is called "Custom Search" What custom search has on it are two option buttons "AND" & "OR". Then it contains Checkboxes with "Filenumber", "Incident Type", "Date of Occurence" and a few others, but those three...

I have a report with about 4 subforms. I have all the properties set to "can grow" "can shrink" = yes. The problem I am having is that if there is two or more records of information in a subform it overlaps the next subform. Is there a way to tell the subforms to move...

I have a messagebox and what i want to do is create a newline inbetween information. So like my msgbox outputs fields that need to be filled in what i want it to do is have a return inbetween them. i.e Incident Type First Name Last Name etc... right now I have the code Msg = Msg &...

Extremely confusing, do you think you could give me a one line example of each. Like, what to write to add statements to the AND and the OR. Thanks. I'm not to Knowledgable in sql, but when I see an example then I can expand on it.

Jeff Bridgham showed me the following code in a thread where I asked "I have a form and it has about four fields. Filenumber, last name, first name. What I want to do is if one or more of these fields are blank when the user tries to add a new record or to save the current one, I want a...

I have a form that is called "Custom Search" What custom search has on it are two option buttons "AND" & "OR". Then it contains Checkboxes with "Filenumber", "Incident Type", "Date of Occurence" and a few others, but those three...

Thanks, that's good stuff...Do you think you could possibly tell me what each statement does. Like explain what their purpose is. Thank you

I have a form that is called "Custom Search" What custom search has on it are two option buttons "AND" & "OR". Then it contains Checkboxes with "Filenumber", "Incident Type", "Date of Occurence" and a few others, but those three...

I have a form that is called "Custom Search" What custom search has on it are two option buttons "AND" & "OR". Then it contains Checkboxes with "Filenumber", "Incident Type", "Date of Occurence" and a few others, but those three...