Search results

trying to archive some data, see below script it returns an error message cant find expression "|" Private Sub Command227_Click() Me.[Archive] = True DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Me.[List220].Requery Me.[ArchiveDate] = Now() End Sub any ideas

Colin, but i need them to return J for junior and S for senior, at the mo the return -1 and 0. did you get them to return J and S ??

I have this in the original update query (under 16) >DateAdd("yyyy",-16,Date()) And this in a second update query(Over16) <=DateAdd("yyyy",-16,Date()) Two fields One junior and one senior, it retuns either -1 or 0 wich identifies junior or senior. tried the above it just returns mismatch...

cheers neil, sorry newbie would this be in the deafukt value or in the query criteria

Ok i know just one question a day. (Have searched) I have a query return a result in one field if someone is 16 and under it returns a 0 in the second field if someone is 16 and over it returns a -1 what i need is the query to report a J or S as its finding. So what i thought of was. So...

SJ, i thank for your help over the last few weeks. i am trying to learn and feel i understand a lot more now. you dont have to answer my questions. i am reading searching, and trying to unserstand. if i get stuck im sure there are people willing to help. and in years to come if i can...

i have a combo box where i select a CityTown the next text box identifies the county and the next identifies the postcode. when inputting this works fine, but when i check the data table it has not recorded the information. the city town county and postcode run from a table to query to the...

would like todays date to be inserted automatically in a field i tried =date() but this does not seem editable it says control is bound Also when i look at passed records (Yesterdays) it updates (or shows) todays date. any ideas have searched not sure what im doing wrong.

yes many thanks how did you do it.

Have searched for two hours now no luck. i am trying to add a table/Relationship to an exsisting query for a form. See attached every time i add (CityTown) relationship/table /query to the exsiting query (qryForForm) it locks the current records. Extrememley stuck Newbie trying to learn...

ok the error message that im getting says: The specified field '[Initials]' could refer to more than one table listed in the FROM clause of your sql statement. confused, because the other tables do not refer to Initials.

ok its down to the relationships. but i am very lost please see attachment.

ok no probs, will do in future. all i did was add a combo box from a query i made, and now for some reason the changing data in a record is not possible. the computer beeps at em if i try and change any data. i cant add a new record , everything seems to be locked. no record locks are on...

any ideas cant enter date now, when i try windows bleeps at me.

how do i add a table to a select query how do i make them have a relationship.

Ta thank you for your paitents this works (I think) but doesnt change the rest of the data. just the serial numbers. the best way to learn is making mistakes ( I seem to make a lot of them)

right i used the following =Nz(DMax("[EKGB Number]","[qryForForm]"),0)+1 this seem to wok fine until i went back changed a record, and reopened it tried a to start a new record and instead of increasing the number by 1 it returned a 0 tried another new record this returned error. any ideas

trying to use this as a source code to look up numbers and records. it returns a syntax error. SELECT qryForForm.EKGB Number, FROM qryForForm ORDER BY qryForForm.EKGB Number; any ideas???

would like an automatic serial number when i create a new record.(i.e.159352) This number needs to be updated annualy to a new number. how do i go about getting 159352 in record 1 and then to update to 159353 on the next record. very new to access sorry is just creating a table ith all the...

your right sorry, i just need to update the recors annaully any one got any ideas