Search results

I'm having hard trouble doing print preview current record from form with subform to a report. When using the code below I'm getting an error for: The specified field [PolicyNum] could refer to more than 1 table listed in the from clause of your sql statement. Dim strDocName As String Dim...

I'm having trouble getting my subform to go to new record from a main form. How would I go about making a command button(new record) on a main form link to a subform. Example: After clicking on command button I would like my main form and subform to go to new record. Thanks, Michael

I have pop up form for report selection. In my drop down i have certain reports that need to have start and end date. I'm using this formula to show or hide start date field and end date field. If Not [Report_Selection] = "VehiclesNotRecovered" Then StartDate.Visible = True EndDate.Visible =...

How can I show top ten records from 2002 to 2004 along with the percentages of increases or decreases (will connect my query to a report). For example if I run a query for 2002 I will get top ten cities, but I would also like to view 2003 and 2004 at the same time and compare the differences...

Hey, My compact and repair recently been giving me a problem with my AutoNumber(primary key). I have a quiz made for every department in my company, I'm sure you all aware once the information is being typed in a form AutoNumber(primary key)set a new number. I've compact and repair the...

I made a pop up form for employees selection. I would like to know is how I can have radio button selected along with date entered and go to that specific report? Take a look at the attachment. I have 3 report to choose from, but I would like run report1 from 1/1/05 to 1/10/05. My Start Date...

This is more of a favor for anyone who is interested in helping me on a questionnaire database. I have a database that gives the questions for managers to answer. The questions are based on YES/NO/NA I'm running the total by number of Yes divided by questions answered. It a little complicated...

I'm would like to use WeekdayName function that returns the day of the week. Formula: WeekdayName (number) number is a value from 1 to 7, representing a day of the week Is there a way I can use the WeekdayName function with my date field that will give me the name of the day? Example...

I have a report(rptTopStolen) running from a query(qryTopStolen) for top stolen vehicles. My report shows me 171 records(make&model), is there an expression that I can use to shorten my search by either looking at Top 10 stolen vehicles, Top 20, and so on? Right now I'm running my report in...

I have a query that gives me top stolen vehicles (descending order). I would like to add a field that will give the numerical numbers. For example HondaCivic 63 HondaAccord 26 JeepCherokee 25 I would like my query to look like this with a new field 1 HondaCivic 63 2 HondaAccord 26...

I have a query that I would like to put in a report. Before I do that I have an expression that runs stolen car make and car model. How do I get rid of duplicate and put car make field and car model field together? I attached a sample database. If you run the query you will notice I have lots...

I have 20 Fields in a Form. I would like to spellcheck only 1 field instead of whole form. Also, how can I spellcheck only current record instead having it go through all my records. I just would like to have a spellcheck for one field only in that record. The field that I wish to spellcheck is...

I'm having hard trouble making a message box for duplicate record. I made a form as my message box with 2 command buttons for GoTo and Clear. My message box form has 3 fields that will tell the user what is duplicate. Is there a vb code that will tell me there is a duplicate record and what...

I made a database for all my supervisors and managers (roughly 15 people). Database is placed in a shared network folder from my drive. I recently spoke to someone about using a replication. He said it best for me to use the replication instead of shared network folder because I have high...

I'm having trouble making a crosstab query or a query in general. I doing a Grand Theft Auto Database. The database keep track of all stolen year, make, model vehicles. I would like to have a query that will give me total (count) number of stolen vehicles each month. For example let say I have...

Is it possible to make a weight score database? I have a database with radio buttons for Yes, No, and N/A. I would like to have a total score that will give you number of questions answered using yes and no only, but have the form divide number of yes by number of questions answered. For...

I've been getting a problem with opening a database. It doesn't open at all, but the ghost file is there. The only way to make the database open is log off my username. Have that ever happened to anyone? If so, how do I make it stop? Thanks, Michael

I would like to know how to change access background color. I have couple forms that are pretty small size and I wanted to change access background color instead of maximizing the form. I searched the forum and was unable to find anything. Please help! Thanks, Michael

I'm having trouble with selecting a record in a combo box and make the tab control show all information on that record that I selected. I have a tab control with customers info. (name, address, phone, and etc...). My combo box is running from a table called Customer and field name is Agent. How...

Can I make a text box with more than 255 characters? I'm pretty sure the answer is no. I thought maybe there's a vb code for it. The way I did it was I made 2 text boxes and put them close to each other so it looks like 1 text box (Form View). The only bad thing about it is that sometimes the...