Help - Select Query & Finding Record Question


all, I have a couple questions. First I am trying to create a select query that will show the results that I have two fields , one is "Date" & the other is "Current" For the date I am using the a between statement "Between [start] and [end]. Under the "Current" I have "Applied" & below that I have "Overage" The problem is when I enter my date range, it shows all records with the Overage or Applied, but if I go & remove either "Overage" or Applied, then it works fine.

Is there somthing that I am missing


Second question is when using a find command box, is there a way to have it search multiple tables, if so how would I set the find box to search both tables, if the table names were called Let say Table 1 & table 2

Posted On: Monday 22nd of October 2012 05:57:50 AM Total Views:  264
View Complete with Replies

RELATED TOPICS OF Microsoft Access PROGRAMMING LANGUAGE




Code length too long on one row help!

I have written a bit of code in a Microsoft Access 97. The code basically creates a Microsoft outlook message. I am trying to add in the message that I want to display in Outlook by using the MyMessage ="" command. But the message I want to add is too long to fit on one line of code - I get to the end of the line and can no longer type any more! I have tried to add the second part of the message to the next line but all I get is an "Expected line number or label or statement or end of statement" error message. I think this might be because access keeps putting a " at the end of the first line - every time I remove it and add the " to the end of the second line it keeps adding it back to the end of the first line! any ideas would be gratefully received!!!!!
VIEWS ON THIS POST

257

Posted on:

Monday 22nd October 2012
View Replies!

Database help

hi i need help if there's anyone who's willing to help me out please do.....it's about microsoft access....i have an assignment to give up for tomorrow and im getting trouble with it. If you think you can help please give me a shout out...
VIEWS ON THIS POST

171

Posted on:

Monday 22nd October 2012
View Replies!

Relationship help

At least I think I would do this as a relationship. I have two tables in my database. One of them has store numbers, address', phone number, ect. I have a form to enter information into the second table, but I don't want it to accept information if the store number is not set up on table 1. Maybe this is done with validation, but I can't figure it out.
VIEWS ON THIS POST

188

Posted on:

Monday 22nd October 2012
View Replies!

Digital Signature for Access help!

, I am trying to figure out how the digital signature cert works for an access application. I have completed my program, access db and access front end. This is going to be used on a network drive and multiple people will be using it. Right now I get that "This file may not be safe if it contains code that was intended to harm your computer" on all the computer that open the mde file. From what I am reading I need to get a digital signature for the file. Is this something I purchase and code into the file Or do I have to get the cert and have the IT department install it on a server Any explaination of the process would be great.
VIEWS ON THIS POST

188

Posted on:

Monday 22nd October 2012
View Replies!

Query problem, help!

New problem for you to solve! I'm making this movie db and right now i'm at the search form. First of all, take a look at my search form so you know what i'm talking about. (sorry for the Swedish in the picture) My problem is that when i write a title in the title field, at the same time as all checkboxes are checked and hit "search!" I find all titles in my db. The query do not care about the title field... Right now my query looks kind of like this (mini version) SELECT Movies.Title, Movies.Genre, Movies.Release FROM Movies WHERE Movies.Title LIKE "*" & Forms!frm_searchk!title & "*" AND Movies.Genre="comedy" AND Forms!frm_sok!comedy=TRUE AND Movies.Release="2000" AND Forms!frm_search!year2000=TRUE; How can I get a query that looks at ALL the search criteria and brings me the endresult. Thank you for your help!
VIEWS ON THIS POST

211

Posted on:

Monday 22nd October 2012
View Replies!

Query help

I made a playlist database with the following tables: Artist, album, song, genre, and a table with all of that information in it (artist, album, song, genre) plus a track input. I want to query the tables now so that, for example, a specific genre is queried kind of like a playlist and the artist, album, track, and song information shows up for all the artists that are in that genre. If you need me to explain further, please let me know.
VIEWS ON THIS POST

282

Posted on:

Monday 22nd October 2012
View Replies!

How to get help??!!

I've posted here a few times and haven't gotten but 1 answer. If anybody can tell me what I'm doing wrong or if there is another forum for beginners to get "stupid" questions answered I would appreciate it.
VIEWS ON THIS POST

165

Posted on:

Monday 22nd October 2012
View Replies!

Update query help

I have a table with trailer numbers currently on the yard. I also have a prompt to enter trailers as they are leaving. I would like an update query to then remove the record from the OnYard table. Is this possible
VIEWS ON THIS POST

495

Posted on:

Monday 22nd October 2012
View Replies!

Autolookup help

no
VIEWS ON THIS POST

332

Posted on:

Monday 22nd October 2012
View Replies!

Please help (newbie)

I would like to make my cursor automatically go to field 1 of my form upon entry, I would also like to know how to enter data on a form without it copying to all records. I want the data to stay on the current record only. Could some please assist me with this. I got Access for dummies, but its not helping.
VIEWS ON THIS POST

155

Posted on:

Monday 22nd October 2012
View Replies!

Check Box / Text Box enable help

I've got a text box that is disabled, and want it to become enabled when the user clicks the required check box. I've got the following code, and can't see anything wrong with it, but for some reason it doesn't work. No error message appears, but the text box stays disabled regardless of whether I check the check box or not. Private Sub Successful_Click() If chkSuccessful = True Then txtDateAppointed.Enabled = True Else txtDateAppointed.Enabled = False End If End Sub Anyone have any ideas Dan
VIEWS ON THIS POST

138

Posted on:

Monday 22nd October 2012
View Replies!

Report help

I am creating a new report in access and have gotten it done but I am having trouble with the formatting on it. when i view the report its cutting off my field titles as if theres not enough room to show all the text. it is doing this on my entered data as well. i changed the layout to landscape and legal but it didnt help. any suggestions TIA
VIEWS ON THIS POST

149

Posted on:

Monday 22nd October 2012
View Replies!

Need help with basics

I have a little experience with Access. But thats only really the basics. Basically my database is very simple. It holds data about customers, names, addresses, etc. Along with a review date. Plus it holds information regarding the location (in a filing system) of important papers for that customer. Basically the system is used to find out where the customers papers are located. As well as a query that can be ran on any review date, and the address taken from those records (that match) and shoved into word in a list. My problems are these, 1) If a query returns back with no results. How can I make it so that a message box appears explaining so 2) When editing a record in form view. Is there anyway of creating a 'cancel' button that will undo any changes that have been made to the record It seems that as soon as you close the box it doesnt ask if you want to save the changes 3) How do I create a delete button so that I can delete a record 4) And lastly, what would be the best method of going about getting the address's out of records via their review date as mentioned above I have a query that will allow you to enter in the review date you are looking for, but after that I am lost lol. I know these might sound like very pathetic questions to ask lol, reading the forums you all seem so knowledgable on these things so I really hope you can help a newbie lol.
VIEWS ON THIS POST

306

Posted on:

Monday 22nd October 2012
View Replies!

I need help on command buttons

I want to create a new database which has a startup form that has 4 command buttons.. My problem is that I want that every click of the command buttons will take me to the main switchboard of the other/different database.. How am I going to link those buttons to different databases anyone help me
VIEWS ON THIS POST

89

Posted on:

Monday 22nd October 2012
View Replies!

Drop down help

My database is set up with a sub form showing: Mfg, Model, Serial#, and Type. When I drop down and choose the Mfg, I then go to the next drop down (Model)and the only choices I have are those associated with the Mfg I just selected from the previous drop down. On my Enter Repair Data form, I want to be able to drop down a box for Part Number and then have a drop down field for the Part Description to match the part number that i just selected. Then I would like to have the next drop down to show a unit price for the Part Number and Description fields that I just entered. Is it possible to accomplish this with an existing Data Base My data base is 1.61M so it's too large to upload here, but if someone can help me my ICQ # is 65-489-369, e-mail is huntiir@bellsouth.net. I can upload a copy of my database if needed. I also need to have a field added to another report in my data base sowing the total labor for units shipped on a particular date to a particular customer. The report already totals parts used in the repair of the units for that date. I just can't seem to get the total labor to show up. I was also trying to set up an inventory Report on parts used for my repairs where it will calculate the number of parts in stock in the form of: RR#, Part#, Description, Unit Cost, and Total Units in Stock. You can see that I am somewhat complicated and ignorant to the use of Access. Can you help me out please
VIEWS ON THIS POST

90

Posted on:

Monday 22nd October 2012
View Replies!

Access -vb help

Dim con As ADODB.Connection Dim rs As ADODB.Recordset Dim db As Database Private Sub cboiden_Click() Dim q, r As String r = "select date from instbl where identity='" + cboiden.Text + "'" txtdate.Text = r End Sub Private Sub cmdquit_Click() End End Sub Private Sub Form_Load() Set con = New ADODB.Connection con.ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\stock.mdb" con.Open Set rs = New ADODB.Recordset rs.Open "instbl", con, , , adCmdTable While rs.EOF = False cboiden.AddItem rs.Fields(10) rs.MoveNext Wend End Sub I have done the code like this , but the problem is that when am cliking the combo box value , am getting in the date text box as select date from instbl where identity=100 , instead of date why this is happening. Here the combo box value is 100 Any one plz help me Sagar
VIEWS ON THIS POST

83

Posted on:

Monday 22nd October 2012
View Replies!

need help using the split function in mdb

First, my knowledge is limited so please forgive me. The problem I have is a persons full name in a column and I wish to have first name in a column and last name in a column. ex: John Public I would like it to be John Public
VIEWS ON THIS POST

94

Posted on:

Monday 22nd October 2012
View Replies!

Anyone help with this one?

Just trying to learn, I have a selection box where I can choose country, after I select the country a table is created with 3 columns from the database I then want to post the record from column 1 to a processform.asp "which works fine" this column is called companyname. Here is what I have Choose Country Companyname Contactname Country If anyone can help with this it will be very much appreciated.
VIEWS ON THIS POST

92

Posted on:

Monday 22nd October 2012
View Replies!

Creating database documentation/help

Hi I need to create a documentation - help system in my Access database. Can you give some guide lines and tips General of course... like how to link a help file or something like that... thanx for the helping hand
VIEWS ON THIS POST

88

Posted on:

Monday 22nd October 2012
View Replies!

help please

I am writting a macro in acess that will open and update an excel worksheet I am trying to use thr RunApp but do not know how to word the commandline I have tried to put open c:\my documents\checktest and have changed the word open to run but get the same error message "Microsoft Access cannot invoke the application using runapp" Can anyone please help me
VIEWS ON THIS POST

88

Posted on:

Monday 22nd October 2012
View Replies!