I am using 97 and have been running into problems with tutorials from microsoft since they are in 2000 format. Its not a big difference so maybe I just cant figure it out...
Anyways, I wanted to make a list of the reports I had for the user to click on one and have it pop up. Anyone know how I can make this list?
My idea is to somehow create the names in the list box using a query or something and have them be links to the report somehow...
I am creating a database that people can upload links to pictures within the database. (I do not want them to upload the pictures themselves because I am afraid the data will get to large - or am I misunderstanding how pictures are added to a database in access?) Now I want to be able to put those pictures in some reports.
Questions: 1) is it possible to insert a picture from a link (instead of an attached picture)? 2) If not would it work if I uploaded the picture to the database? 3) Am I incorrect about the way access deals with uploaded pictures? Does it just save a link or does it actually upload a picture into the database making it that much larger?
I have a main form (in a single form view) that show a record from a table. I am going to add a sub form (probably a continuous form view) which can show a list of fields (probably a name) from all records from a child table that match condition PrimaryKey = ForeignKey.
What is the best way to make the list of the fields sort of clickable so that I can click on any of them and e.g. open a form with information about a child record? Should I look for hyperlinks in reports, a list box, a continuous sub form with records?
I found 2 examples of code to refresh my attached table link to sharepoint lists.
I have a scheduled task open my Access 2010 db and an autoexec macro runs and closes the db.
My problem is my tables disconnect from sharepoint 2010 and the update fails.
I added the code I found to a module and added a line in my macro to run the code. Now I cannot get the code to work.
Am I at least on the right track? I just want to know before I spend many hours getting this code to work.
These are the two locations of code I found.
[URL]
I think part of my problem is that I have a regular table that I add a txt file to that is not linked to sharepoint so I need to exclude it from the code.
I was recently doing a little Spring Cleaning in my database and deleting old tables and queries that were no longer used or had been for experimental purposes. Unfortunately, I unknowingly deleted a query that was being used by a report I still needed and it took me several hours to find and correct the problem.
Not wanting to repeat this mistake, I began searching for a way to display my reports, queries, and tables and all the objects each is linked to. I thought it would be nice, for instance, to have a hard copy list of all my queries that showed where they are derived from and what other objects reference them. Is there a way to do this?
I've tried using the "Relationships" button and working with the Documenter, but I haven't found what I'm looking for. I have also tried a Google search, but, admittedly, I may not be using the proper terminology to get good results.
I have created my tables and form and am now trying to run reports to organize the data. I have figured out how to group the individuals by group and treatment, but can't figure out how exclude individuals from the final list if they are already in another. As background, some of the individuals are eventually excluded from the experiment, though I keep the initial data. When the exclude individual checkbox is checked ("True" on the report) I do not want the individual to be listed in the "False" list, even though there are entries for that individual when that checkbox wasn't checked (when it was "True"). This is so I can get an idea of the current totals in each group.
Implant Period >Treatment >>Exclude individual? >>>Individual ID
I feel like this should be a fairly simple task, but I cannot figure it out... Maybe there is coding to exclude individuals from the "False" list if they are already listed in the "True" list?
I am still trying to get a hang of development in access 2010.
I would like to design a form with a listbox or a combobox which holds all 8 of my reports (a table has all the reports), with a Print and a Preview view buttons. In addition, the user must be able to select if they want to view the report by month, quarter and the year in question.
How do i have a specific report print or previewed based on the value selected in the listbox or combobox and the date criteria.
I am trying to build a training database, I want to open a form which shows the employees details, when open I want the attached Sub form to show a list of training documents completed to be listed. I have got it so that the sub form shows a list but of all the students, but I just want a list for the the specific person.
I have a dropdown list of reports that is supplied by table. I also have listbox that are populate by another table. I want to be able to run the reports from the dropdown and from the listbox ....whatever the selection is to pull that info from the report and display.
I do not have the privileges to write code, but can use macros and Expression builder. I have written a bunch of queries and made reports for each of them. What I want to do is to be able to choose from the list of reports and view the chosen one. If that cannot be done without code, then to choose from a list of queries and then view the report made from the query. The user needs to be able to choose.
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
I have a table that has several fields that contain a date if a user is licenced to use a certain piece of equipment and is null if not. Each recor has other data in it such as name, and a unique identifier (numeric). What I want to do is make a list of the fields which have a date in them to create a licence for what they can operate. Any help on which way to go...pretty new at access.
Hi. First of all, this is my first post, so tell me if I'm being stupid.
I have a simple form, 'BuildingID', which contains a list box and two buttons. The list box lists a field from the records in the table 'BuildingID'. The two buttons are 'Add Building' and 'Delete Building'. The 'Add Building' button works fine, but I cant figure out how to make the other one work.
I want to be able to single click one of the records in the list box, then hit the 'Delete Building' button to delete the entire record. So I'm guessing I have to somehow make the record that I click on in the list box current when I click on it, then have a standard delete record button.
Code: SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;
My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:
Code: SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];
Both of the tables that are referenced have the fields TypeID and Type.
I am working on my DB for work and would like to display all of the report names that are listed in the Reports-Objects of my DB.
I would like to display a Form with two boxes. The left box would display the names of the reports as listed in the Objects-Reports. When a report is highlighted in the left box it would give a description of the report in the right box. When you double click on the report name it would open the report.
Since I am fairly new to Access could you give me an example of what I would like to accomplish? Your assistance is appreciated.
I've got a table of associate directors "t_ADnames" and want to build separate tables for each AD name that pulls a pass through query from our data warehouse. I'm thinking it's got to be done with a macro somehow? So it would run pass_query where AD name = "John" and insert into t_john, then it would check the next name in t_ADnames and run the same query for say "Mark" and insert all his data into t_mark and so on until the list (of about 12 people) has been completed.
In Access, when using Look Up function, Table/Query, how do I make more than 1 field from the query appear in the drop down list?I will be doing the same thing for students and some other tables. But for this example I am only wanting to show instructors first and last name and their ID number in the drop down.
I am using
Code: SELECT instructors.first, instructors.last, instructors.ID FROM instructors; in my Classes table.
What am I doing wrong?
I would like for it to show their instructor first and last name but actually put the ID in the field as I will be using that key for various relationship based functions. Show the first and last name to the person who will be using the database, but actually put the ID in the field so I can use it as a common field across other tables.
Runtime Error 3075? I have attached a copy of my database. I am trying to make a calendar form with the list boxes having two columns. It works fine with the strFieldID and strFieldName but when I try adding the strDone I run into the error.
-if the result of a test is more than the normal value , i want up marked . -if the result of a test is less than the normal value , i want down marked . -if the result in the limits of the normal value , no marked.
Hi all, i have a 2 fields in a subform named "HRS_ABSENT" & "ABSENCE_REASON" i'm trying to create some code that will display a message if the user inputs any number into the "HRS_ABSENT" field & leaves the "ABSENCE_REASON" field empty. I want to force the user to select a ABSENCE RESON (these are 3 letter codes) from the drop down list, if they enter a number in the HRS ABSENT field. Ive tried the below code but it doesnt do anything :-(
Anybody please help me out? ------------------------------------------------------------------------- Private Sub Form_BeforeUpdate(Cancel As Integer) If HRS_ABSENT = >0 & ABSENCE_REASON = FALSE Then MsgBox "Please select an Absence reason" Cancel = True End If
I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". For example, if costumer "Jack" has ordered as the following:
Code: ID costumer product quantity unitprice orderdate
12 jack A 4 10 25/11/2014 13 jack B 5 5 25/11/2014 14 jack C 1 4 25/11/2014 15 jack F 3 2 25/11/2014 16 Jack G 4 8 25/11/2014 17 Jack H 1 7 25/11/2014
Then I make a report based on the above table and issue that as the invoice to the costumer, who is jack here.
How can I make a unique invoice number, which automatically increases sequentially for each invoice? Do I need to add a new column to the table? I also need to be able to look for a specific invoice based on the number, or date.
I am having a small issue with creating my report, that being I am actually trying to create two different reports in one. I first need to report how many of an item is located in each location.
Then under that I need to list the serialized items of each item in each location. I can run them both just fine separately in the detail section of the report but I can't seem to get them to both run at the same time. I would just put them together so it reads
Location Part number Serial number Serial number Serial number
But my boss told me that's too much detail in on place at one time for the customer.
Is it possible to add a second detail section to a report, or something that is equivalent and do the same thing?
TRANSFORM Workersdetail.workername AS CountOfedate SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate] FROM Workersdetail GROUP BY Workersdetail.[Workername], Workersdetail.[attendance], Workersdetail.[workerhourenter] PIVOT site+Cstr([workerhourenter])
I wanted to know that, is there any option through which my report gets autoupdate or refresh incase of addition in SITE field (as mentioned with PIVOT)?
I have a form with a Yes/No checkbox. Sometimes a data entry person will use this, sometimes an associated report is printed and a technician in the field will be required to fill check the box by hand and return the report for data entry. what I have tried to format the check box, if the box isn't already checked, I can't get it to show up clearly on the printed report. It's set to Visible, width 6pt, solid, black, always display, yet it still is barely visible. Ive tried increasing the grid line thicknesses, making it shadowed, nothing seems to work. Is there anything I can do?
