Recent content by mara

Hi All, I am on a deadline and am really struggling. I have been working with access for just over a year and recently created a web database which has to be put up onto the sharepoint server. My Navigation form contains an unbound textbox and an unbound combo box which contains types of the...

Sorry about my belated reply, I am not too sure how to upload things, but it probably isn't worth the hastle at the moment. but thankyou. Just another question if you could help? I have a text box on a form that is used as a search to show specific results for a query. Once the query results are...

It does, but when you paste in the results it was turning those backwards. I don't know wether it is just a bug, or whether there is something else in the settings that needs to be changed. for now it isn't that important so I'll have to play with it a little. thankyou.

The four "a"s are apart of an alpha numeric codeing, which in the case of there being letters for that particular part of the drawing (which gives us details on an address), I wanted them to be auto capitalised. The numbers are set as text. Because there can be letters inluded in apart of the...

Hi, I am not too sure whether this is possble, but if anyone could help it would be much appreciated. At the moment I have an Input Mask on my table for drawing numbers for 15 drawings per form, being >##\-aaaa\-##\-#####\-## When the form is then completed it ensures that all fields for the...

Hmmm, I am not sure whether that's the code I needot not. Every code seems to have no effect, or comes up with a debugging error. The code I'd originally beentrying was similar to: If Me.combofrmName = "Incident Report" then docmd.Openform(frmIncidentQuery) And If Me.combofrmName = "Hazard...

Hi there, I am creating a HR database with forms such as Incident, Investigation, Hazard, Non conformance, appraisal ect. I need queries so that each report can be somehow found without having to go through all the data. I have created a form called "searchcentre" where I have placed unmanaged...

I am not to sure how to show this? I think I may have figured out the cause, The form I has has the Site code ID as the form and then the report details as the subform. I have a drop down list for the Site Code ID and when you type in the code manually and click enter, the result appears on...

I have created a database for a company that shows all the information from when one of their sites is updated. I have done this by a means of four tables, being site info > site code > reports code > report I have a query that I use as a search by someone inputing a word or code into a...

Hello, I was wondering if I could get some advice, only being new to access I am unsure on how to proceed. I am creating a database that holds a the information an employee submits towards the job they are working on. Each job has three main unique points in can be identified on (the name, ID...

I am still a bit unsure on what I am doing, but I have solved the many to many relationship with having a different secondary table for each section (both employee and report). (Ie rather then having an employee with one form number, my employee can have many different ones each assigned to a...

I am familiar with querys, and have even tried using a combo- box (both linked and not linked) where the person would select their name, as apart of the form, and the query would be sent it as a pdf of only their reports. Also I tried as the days date to minimise the amount sent and so on, but i...

I am only new to access but am at the moment creating a Human resources Data base which will contain all employee information as well as various reports such as incident reports and non conformance reports but be able to link employees to reports. I am not sure if this is correct but: to solve...

I seem to have trouble when it comes to doing this as my employee names are a dropdown menu create when someone adds an employee into the employee detail area. How would I go about this? Or would it be simpler to create a report based on the Incident reports number? which is an automatically...

Hey, I am new to access and at the moment I am creating a HR database with two main switchboards, one which will contain new forms and show no personal data, to sit on all employee machines. The other will be for management to have access to all the information which the employee has filled...