Search results for query: *

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?

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 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 &...

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...

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...

Hi, I say this question is for guru's only because I need EXACT code. I'm a newbie to Access and have been trying to solve this problem, which seems very simple for months now, and it's holding my project back. Here is the issue. I have a report called "MainGeneral" I also have a...

Hi I have a quick question for anyone, it's probably an easy one to answer. What code or what not do I have to include in my form so that when a user opens the form all fields will be blank? Right now, if a table contains records and the form which is linked to the table is opened it displays...

Hi everyone...I created a table with the following data... First Name : Last Name : User Name : Password. I then created a form called "Log In" which has two textboxes, one for the user to enter their User Name, and the other one to enter their Password. There are a couple things...

Hi, I'm trying to write a piece of a larger program that will allow the user to view all the available .txt files in c:\projects\qrt4. I have no idea how to do this and have been searching the net for some info with no luck. So if anyone has any idea it would be greatly appreciated.. Thanx...