Search results

Hello, I am slowly tip toeing into the world of Microsoft Access and am finding it quite interesting, however I have a strange table requirement that I am trying to get working and to be honest I am quite stumped at the easiest way to do this. Basically the table is a 'test request' table...

Hello, I am wondering if anyone has an example word document they would be able to send me that would show how merging images works. Basically I have a spreadsheet which has a column for the Building name, and another which is the Room name and then a third column which is the image filename...

Hello. I am slowly learning more and more about access and its various abilities. I suspect i am moving more towards a PHP and MySQL based solution with this question, but i will ask it anyway. I am looking to create a projects database, where there are employee's who have projects, and...

I am curious how people handle reporting in their database systems, basically i am trying to work out how i can allow my system to dynamically generate reports but still allow for traceability. The logic is that i would need to potentially generate a reportID, and other report information in a...

Hi, I have quite a few different calculations that i run depending on the analysis type that was requested from the client. Because of this i was trying to work out how to best structure the system to handle these different calculations that thought possibly about storing the SQL in a table. I...

[Solved] Import Specific Cells from variable sheets into Access Tables. Hello Once again, I am trying to get an import system running in the backend database to import results into the appropiate tables. Some parts work quite well where the format of the spreadsheet (or CSV) is that of headers...

Hello, I have two tables that i use a lot, and want to try and make the system a little bit more user friendly, so thought it would be worth getting a few crosstab queries or crosstab forms going to make data entry easier. So essentially for the first part, I have two tables, one is Samples...

Hello. I have a spreadsheet that i want to import into an ExternalData table, basically it is normalised (i think) but to be sure i want to import cell values based on the values in other cells. So looking at my spreadsheet there is a cell value (B6) that contains the value "Sample...

Hello, I am starting to build up a little bit more knowledge about Access, and trying to work out how i can best achieve the desired result, basically we calculate things based on spreadsheets and so forth with results that are obtained from email, spreadsheets, forms and so on currently. I...

Hello all. I have a table called clientcompany, and what i want to do is have field in that table called normal turn around time (normaltat) as a number field (as in the number of business days the project needs to be completed in for this client). I have a project form where the project is...

Hi All, I have a system i am working on which will hopefully let me automatically generate subsamples of parent samples based on if they are selected, through the sampleaction query, which basically filters only the selected samples for processing. The sample table contains a whole lot of...

Hello. I am using the following code to import two csv files into two seperate tables, the files are distinguished by chemistry or samples, and they are supplied from the laboratory as is, so i am keen to be able to use outlook to save the attachments to a directory if they contain...

Hello. I was wondering if anyone has implemented their own access control solutions in their access databases. I got a system working for login but want to now limit users access to both forms, and view, add, edit and delete access to each form or report and was wondering how people have...

Hello. I feel like i am not getting very far with what I am trying to now achieve, i want to be able to have a checkbox (preferabally not in the table since this would be a multi-user database) that is displayed in the form which is a datasheet. Basically the form has an autoID element which is...

Hi All, Hoping you might be able to help me, i have a strangly designed table i am keen to get a query working on, the table is (sample_register) which consists of: SampleID(AutoID), JobID(LookUp-ProjectID from Project Table), ParentSample(Lookup-SampleID), Description(Text), Recieved(Date)...

Hello. I am struggling a little bit with using a checkbox to generate multiple values in the same table. Essentially I have a projects table, that is linked to a sample table by ProjectID. The sample table is essentially the follow fields: SampleID, ProjectID, Sample Description, Sample...

Hello All. I have a table that I am trying to get spreadsheets imported into, I am self taught (very limited knowledge) and I am progresivly getting better and better at getting things to email out, and loops working and the likes. I am stuck at the moment at importing spreadsheets, that...

Hello All. I was hoping someone might be able to help me come up with a solution to how I can handle a requirement. I have a query that has a calculated field being total-time which is the different between a start and a finish time, and another calculated value is average flow which is the...

Hi Again All, I am slowing putting together bits and peices of my database and some parts are working quite well. Anyways my question relates to Resource Scheduling. Basically I have a project database which is linked to a sample database for that project and each sample has a 'test...

Hello All. I apologise if this is a simple question but i am trying to work out how to best get this report working for my system. Anyways i have a "Projects" form in which i select the customer it is for, and then all of the project information is entered into the system and the staff...