Search results

Hi, I am trying to join to tables using the Employee ID field. Both are views from other databases (previously never linked) one holds the value as number and the other as a text string. I have tried using the to_number function but keep getting the error "JOIN expression not supported."...

Hi, I am trying to make an update query that updates multiple fields from another table. Basically it holds the relational data for staff using job codes and in my database I also hold the employee number for each of the 6 relationships per job. Every job has 6 relationships: Manager...

Hi, I am quite new with access and I am trying to filter a subform. The idea is that multiple combo boxes will apply filters to the subform, then the user will select from the subform and this choice will be used on the form. Unfortunately I am not quite there yet... I have the subform...

Hi, I am trying to write a function to automatically assign an ID like the way autonumber works, but with alphas. I want a 2 digit alpha assigned and I want to reuse and deleted like as if you compact the database everytime a record is removed. The Table in this example is called division...

Hi, I am a total newbie with access databases, litterally 2nd day. I am trying to populate a textbox and the related control source table field with a select criteria. Basically on the form you select a Job Title from a combobox then enter a division and I am trying to get it to select the...

Hi, I am relaerning access again and haven't used in for a few years, I'm a currently trying to build a payroll queries database to log and manage queries. I have a database view of our staff database, but cannot just make table links as I don't have access. I have set the datbase view up...