Search results

I am using Access 2000 on an ME... I am trying to create columns from my rows based on date... EmployeeNo EmployeeName ShiftDate MinsWorked There is a user entered start date called [Entered Date] iif(ShiftDate = [Entered Date],(MinsWorked/60),0) this works on the query, but then I want to...

Hi All... please read on and see if you can help GOAL: To sort my subform data in descending order; I have a subform off a large query... the query has other forms off it... so on the subform I have used the Order By property... qryDeliveries.EntDate DESC :) sure enough when the subform...

Problem::confused: I am trying to conditionaly colour a record(row) in a list box based on one value in it.... Solution::o I was wanting to read each value of a particular field in each record to set the colour of the background! How do I do this? Please HELP!

Hi all... I have a form that OnOpen does; DoCmd.GoToRecord , , acNewRec But, I also call it from another form, using a criteria, but because of the OnOpen event within the form it goes to a new record. I need to be able to bypass the OnOpen event or find a different way of opening the form...

Help all...Its a fixed width file... :eek: I need to match up the CustRef from the text file to the CustRef in my table and update the corresponding fields in the table from the file....here is where I got up to...I am just adding to a test table at the moment... Function ImportFile(tbFile)...

:rolleyes: This code did work, but not it dosen't, I am in dispear, I have read through the other 3251 errors, but not seem to solve my problem. I am now getting operation not supported for this type of object... when I debug its this line it doesn't like: rstDeliveries.Index = "PrimaryKey"...

Help... I have just finished access 2000 database... loacally it works fine... but once I take it over a VPN it doesn't. The front end is about 20MB... It seems when I try to open a form its caching part of the DB? I tried to open one of the smaller forms it uploaded 2MB? Should I migrate...

Underlying tables - Farmer, Field(as in crops)... Each Farmer has about 30 fields. In a form I want to select a Farmer and then be presented with a list of his fields... I then in two text boxes want to put a date and a product name (weedkiller)... Finally, I want to select some (NOT ALL) of...