Search results

i am racking my brain with this one. can anyone tell what is wrong with this. i have used many example seaches but when i incorporate them into my database there is somthing that doesnt like this code. please please please please please please help! Me.RecordsetClone.FindFirst "[RETURNID]...

i am using this code im rs As Object DoCmd.OpenForm "frmquery" Set rs = Forms!frmquery.Recordset.Clone ******rs.FindFirst "RETURNID = " & Me.QuickSearch Forms!frmquery.Bookmark = rs.Bookmark the line that i have put ********** wont open the form and i keep getting the error...

in tblquery i have a field date. it its formated to =Date() i also have two more fields 1- month 2- year. what i want is to extract the month and year from the date field. but the thing is, i was it to be visiable when you are in the table "view". but i dont know how to format this.

just a bit of back ground. my project is to create a database for a warranty dept. idealy they would like to create a form that allows the basic details return number, date, customer etc. put they want to be able to list all the items they get returns. for instance, a customer may...

rs.FindFirst "[MONTH][YEAR][RETURN NUMBER][ACCOUNT NO][CUSTOMER NAME] = " & Str(Nz(Me![QuickSearch], 0)) I keep getting error "run time error "13"" type mismatch. ive tried the help pbut i just dont understand it.

i have a search on my database adapted from the one attached. i would like it to display the month field return number (ID) year field the month and the year are formated =Format(Month(Date()),"0") but when i run the query and the search they are just blank, is that because it will only...

i have a search on my database adapted from the one attached. i would like it to display the month field return number (ID) year field the month and the year are formated =Format(Month(Date()),"0") but when i run the query and the search they are just blank, is that because it will only...

i have a search on my database adapted from the one attached. i would like it to display the month field return number (ID) year field the month and the year are formated =Format(Month(Date()),"0") but when i run the query and the search they are just blank, is that because it will only...

please see the example attached, it is a very basic search, double clicking on the return number opens that record. what i would like to do is show the account name and date is the same box. below is the code that i use. can someone please someone help me incorporate something into it...

are you able to do something with the auto number. i'd like it to display R/N "month" auto number "year". i cant seem to get it to display the month and year

the people that i am creating a database for are wantingto have a "date" field but they dont want to manually input it. they would like the date to automatically update to todays date when they start entering the details. can this be done? many thanks michelle

ive created a report the fields in the report are manufacture part code fault code qty i would like to add up the total qty for each manufacture but i dont know how to do this. can anyone help?

ok i have two tables. the main table tblquery and the second tblreturns i want the data from tbl query return number date received date processed to be the same in the tbl returns is this possible?

i would like to run a query that works out the busiest day in a month but i also want to run a range from two dates and be able to convert them to mon ? entries tue ? entries and so on is this possible? many thanks michelle

please excuse the ignorance, im am i novice in the process on learning this. i have a project that requires to create a customer service log of all the queries that come in. i would like to create a form that would enable me to search for the following query number date account name...

please excuse the ignorance, im am i novice in the process on learning this. i have a project that requires to create a customer service log of all the queries that come in. i would like to create a form that would enable me to search for the following query number date account name...

ok heres the thing, im not brilliant at dababses but ive created one for my work. i want to create a query to summarise the information the database is to log customer queries and there is a field for the department responsible e.g warehouse, sales etc. this is a list box by the way i want to...