Search results

both r texts

Hello all. Im trying to update a record in a table based on some values from a from. The idea is to update an issue status on a table where issue reference no. & assigned date/time matches between the table & form data. Here's my sql- DoCmd.RunSQL ("UPDATE [workload] SET...

thanx lag & david. i know i can do this with one table, but im using two tables bcos i dont want anyone to be able to open the actual FE table. here's what im doing- i have created a BE db with one table which is password-protected but password will be shared with select people who'll load...

bcos i need a point to load daily dataload & the BE table is the one open to supervisor for importing the data, while FE table remains closed from everyone.

Im developing a simple task tracking tool. Here's the scenario- Every morning a supervisor will load/import a list of tasks to a database (lets call it workload) which will have- [reference no] [assigned agent] [issue raising time] [assigned time] [issue category] [issue status] this database...

help...anyone?

Hi. thanx for the advice. i'm posting my original database with some data & converted to mdb for your convenience. as u'd see, the log & the breaklog tables are the main tables. what i need is a query that will take the first entry with entry type "in" & the last entry with entry type "out", the...

those field names were just examples to give everyone an idea about the table structure, real field names r different (name is user_name, time is entry_time, date is entry_date etc, entry-type is entry_type etc...). i'm pretty sure my naming isnt the issue, i used underscore(_) for multi-word...

hi, new user here. i m developing an attendance system for my firm using vb.net to build the frontend and access 2007 as backend. here's my table structure- table: logins id username password user category table: log id name machine-name entry-type (in/out) date time table: breaklog id name...