Search results

Hi I have designed a database in access which I am using for assigning work to my shopfloor employees . I have designed a card with barcode for them to check their dailywork. I also have a MS Project to make schedule for all the projects in shopfloor . Everytime when I assign work using access...

Hi I have an access 2013 project in my machine, today I just swapped my machine with another high config machine which has Access 2013 installed in it. But when i tried to open my database i got the below error "The database cannot be opened because the VBA project contained in it cannot be...

Hi I have a form named frmMachineSchedule which has the calendar display. I have a table with the columns Machine, ResourceName,StartDt&Time,EndDt&Time. Now i want to show the Machine running on particular date in the calendar with all table details. Can anyone help me with the query or vba...

Hi .. I have created a system in Access for Assigning work to employees. I had used Barcodes [123456789011] for Employees,Project , Activity,Machines. Now I am planning to build a system in which when I assign work for an employee and a Machine. Only the particular employee can access that...

Hi ..I have a form [Form1] which is used to assign work based on Project, Activity , Resource and Machine. This value gets recorded in a table [tblRecord] which has the fields ProjectBC, ActivityBC,MachineBC,ResourceBC.. All these fields stores value from form1 as a 13 digit number [123456789011...

Hi ...I have created a form called Form1 which has some 7 fields in it. The fields are listed below Activity|StartDate |StartTime| Enddate |EndTime |ResourceIncharge| Machine| The fields resourceIncharge and Machine [combo box] gets the value based on Activity so I have a logic in select row...

Hi ..I am Designing a Database for which I want assign activities to my employees so that when they scan their ID Card daily they will know what they are supposed to work. For this scenario I am using a barcode for each employees and this barcode will be present in their ID Card . Right now I...

Hi ..I am facing a issue in accessing my db file in server. I just splitted my database into front end and back end , placed in a local folder which is shared in network . I opened the files in network from my colleague machine and everything was working fine yesterday .. but right now i am...

Hi .. I created a db in access in which the users login and enter few information in subform which gets stored into a table. Everything was working fine. I just splitted my db into front end and back end . I used my front end to work the same.. but when i click the save button I got an 3073...

Hi I have created a Login form in Access Database in which the users can log in to enter the work information like how much time and which job they worked on particular day , this data is stored in a table . How can make the users to use this form , I dont want to access to be installed on...

Hi .. I have a subform which stores 3 VALUES Start Time , End Time and Work Time..I am creating a macro to check for the worktime greaterthan 8 hrs and send email to particular person . This is the macro function I used.. If [Forms]![RecordSubform]![Label17]>=8 then email database object...

Hi ..I was updating my records by filling a form and entering the data's into a table but all of a sudden i couldn't add data to form and table..can anyone please help on this issue....thanks in advance

Hi I am trying to get my Barcode value from my table, by comparing other field called toolcarejob which is also present in the table and will be given in navigation form, but while executing my code I got syntax error. Any help on below syntax will be appreciated. Private Sub...

Hi I am trying to get my Barcode value from my table, by comparing other field called toolcarejob which is also present in the table and will be given in navigation form, but while executing my code I got syntax error. Any help on below syntax will be appreciated. Barcodefromtable =...

Hi I am creating a table in access database for my company which reads the data from a subform and store in a table. I have 5 values in which 2 of them are combo box and 3 values are time values (start time , end time and work time)..I executed the below insert into statement which throws...