I have been given a form that you pass a parameter into and on the basis of this it performs certain amendments to the particular data AND also runs 2 stored procedures on this data. I need to get the data to display on the form so that the user can visually verify if it is the correct data and then they will on click to execute the amendments and stored procedures.
I cannot get the data to display on the screen? I have tried to create a variable in the VBA code to store the data in and then used a message box to try to display it but to no avail?
I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.
The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.
The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!
I'm trying to place a picture on my forms using a browse button code i found on the net. After picking a picture, the image won't display automatically during run time, i still need to select design view and finally form view just to display the image. Im using the events form current, and the text box afterupdate.
I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests are scored out of 72 and numeracy out of 50.
what I would like to do is write something that shows the literacy numeracy levels of each student after each test. So for literacy, the score ranges are as follows:
What I would like to be able to do is tick whether or not they sat a literacy or numeracy test, enter the score and the db to come up with their level and display it on the form.
I am creating a driving school database and have four different tables. Student, Instructor, Lesson and Lesson Type.
In the footer of my subform which works out what lesson type the student has taken and from which instructor, I have created a calculation to multiply the number of hours a student does to what type of lesson they take.
=([LengthOfLesson]*[cost]) (This works ok)
I then want to add all of these options together. I have tried:
=sum([OverallTotal]) in the footer (This doesn't seem to work)
and then
=[Booking].[Form]![OverallTotal] to show it in the form
The name of the subform is correct (booking) and name OverallTotal is also correct but I keep getting #error message.
I am using Access 2007.I have an application that keeps track of automotive parts and accessories.I have a table called "PARTS" that contains information about the various parts such as "part_name", "part_id", "price" etc.
I also have a website/shop that displays these various parts and also has an image of each part.I have managed to incorporate Microsoft Web Browser ActiveX functionality within the app so that when I scroll through the Parts table using the PartsForm, it automatically "reads" the URL from a field in the Parts table called "ImageURL" and displays it in the Microsoft Web Browser ActiveX browser window...this works great.
I am working on a database where I want some specific information displayed on a form, preferably on the form header. I want to display this on all of my forms. In a standard module, I have a code segment that runs a query returning values, and I assign those values to my public variables. I run this code segment triggered by "on activate" of each form.
The variables contain an Event Date, and an Event Name. I want this information to appear on each form. How do I get this data onto my form as part of the form header, or if cannot put on header section, then in the detail section?
I have created and saved a form in access automatically from database table. But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.
I have a form that a user will use to search records. Upon selecting a record, there are three buttons that allows the user to look at more detailed information. This information will be on the many side of the relationship. So I will have multiple values. The called form is just a popup form that I use for several other instances, like displaying memo fields from other tables.
The problem I am having is that only one record shows up at a time on the called form. I have read through the postings and have changed the properties for Default View, Filter on Load, Data Entry, etc. Nothing seems to change the outcome. I have run the query in SQL view and have no issues. It returns the correct records and multiple rows when expecting. Why they don't show up on the form. There are no errors, just the first record from the many side of the relationship shows up in the form. I would like all records to show up, just like when I run the query.
Code:
SELECT Capability FROM Process_Meetings_Capabilities, Process_Meetings WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID AND Process_Meetings_Capabilities.Meeting_ID = 2;
Button Code
Code: Private Sub Capabilities_btn_Click() strSQL = "SELECT Capability AS Results" strSQL = strSQL & " FROM Process_Meetings_Capabilities, Process_Meetings" strSQL = strSQL & " WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID" strSQL = strSQL & " AND Process_Meetings_Capabilities.Meeting_ID = " & Me!Meeting_cmbo.Column(0)
I have created a navigation form with quick access to the forms and reports I use most often. The Navigation Form (which I named Control Panel) automatically lands on the Tutor_Information Form on a current record. However, I would like for it to open to a blank form instead while retaining the ability to access the current records. Individually, when opening the Tutor_Information Form from the Navigation Panel, it opens to a blank record.
I used a 2 step macro
1. OpenForm 2. GoToRecord - New.
How can I make it do the same thing when landing on the Navigation Form (Control Panel)? I am using Access 2013.
The user select the class from [Combo28] for the unit already in [Textbox named Unit] from Form 1 and wants to list all the students for that particular class and unit in form 2.
I have tried god knows how many different codes. I've been playing with:
Access 2007 Pro.Attempting to use a query and a table to populate a 1:N form/subform using the Form Wizard. The wizard will not display the field names of the query.
I'm trying to write code which writes text into text boxes on a form depending of certain content of other text boxes. The names of the text boxes are all very similar
F.i. R1, R2, R3 ...... R12 if the content of these boxes are empty then the content of the corresponding text boxes VR1, IR1, VR2, IR2, VR3, IR3.......VR12, IR12 should also be empty.
In fact I am trying to write something like this
DO UNTIL i=12 if me.R(i).value = "" then me.VR(i).value = "" me.IR(i).value = "" endif LOOP
But this isn't working. The solution below works but isn't a very nice one, writing 12 times the same code
if me.R1.value = "" then me.VR1.value = "" me.IR1.value = "" endif
if me.R2.value = "" then me.VR2.value = "" me.IR2.value = "" endif
I am creating a 2 level report to confirm an order. Main report already created, runs successfully called as subform/subreport under "OrderDetails" form. Linked to master using Order.ID. There are two versions of the confirmation report that have different layouts for different program types.
The hangup comes when I try to add a "Class Dates" subreport. It lists dates of individual classes and Skip dates. I have created the subreport as "srClassDates". When I add it to the main report, it lists the records. However, when I try to link it to the Main report, an error message box appears with the "object variable or With block variable not set".
I have tried rebuilding both the main and subreports, rebuilt the query, have not found anything that changes the result.
Linker has been working successfully on other subforms. Report with groupings works fine, but I need data from 2 tables both linked to order.id.
Error 91 - Object variable or With block variable not set
I am getting this error telling me that an object variable is not set.
I know which variable it is but when I step through the debugger it sets the variable and all is fine? Issue is that public variable of a class is not getting set when the VBA Editor is not open?
This code runs fine the FIRST time, however trows up a message the SECOND time it is run.
The error is on the line ".Range"
I am trying to sort records which have been exported to Excel.
Dim LR As Integer LR = 5 Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set wbRef = xlApp.Workbooks.Add With wbRef
wbRef.Activate .Worksheets("Sheet1").Activate With ActiveSheet .Range("A2", .Cells(LR, "O").End(xlUp)).Sort Key1:=.Range("C2"), Order1:=xlAscending, Header:=xlYes End With end With
I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.
I have written a DB for work that collects information on a range of events (eg safety incidents, improvement suggestions, etc) and reports on them. I am now trying to improve the security & integrity of the data by restricting user access to menus.
I can use the start up options to turn off menus, etc but want to allow users to use the default right click menu in forms to sort & filter the forms. But I don;t want users to have access to the other default menus (eg the one containg form deisgn). Is there a way to just select this particular menu to pop up on a right click?
Because I have not been able to find an answer to this I tried designing my own toolbar containig the sort & filter commands I needed. I created a custom tool bar using the menu/customisze options and called it "tbarSortFilt".
As soon as I place it in the menu bar it goes "dim" and I cannot select the options. When I over ride the start up options ("shift" key) and then right click in teh form both the default menu come up (as expected) and the "tbarSortFilt" menu lights up -- but is not active.
I have also tried
DoCmd.ShowToolbar "tbarSortFilt", acToolbarYes
to no avail.
Clearly there is something pretty basic I am not doing. How can I use the strat up options to turn off toolbars and then show AND activate my customized toolbar?
I have a table that holds the ID to another table where I pick up the name to display instead of the ID. If a name is added or changed then the ID needs to be added/updated.
The name (and other details) are displayed on a form from 1 to ,many rows.The field that holds the name is a combo box and I can change that field by selecting the bane from the combo box or typing the name in. What I want to be able to do is type in the ID (I'm actually scanning it in from a bar code) but display the name. How do I do this.
As I say this currently works if name is typed (Or scanned in)and the ID is written to the table.On the data tab for the field I have as the control source the ID itself. In the Row Source I have select 5 fields from the second table which includes the ID and name (both from 2nd table). The Bound Column is set to 1. In the Format tab Column count is 5 and column widths is set to 0cm;3cm;0cm;0cm;0cm. This allows the name (2nd column) to be displayed. But the 1st column to be stored on table 1. However I can't scan in the ID which I want.
I have a DVD movie table and a lookup table for the movie genre. One selects the movie genre by opening a combo box which has the values. (Movie typeID which is a number and MovieType which is a text.The records are being displayed in a Access 2010 split form with the datasheet on the left. Any editing can be done on the right or the single record side.I would like to only display the genre for that movie as opposed to the combo box which can be edited and next to it have a command button to open a form in order to change or select the genre for the existing or new DVD.So, I guess what I'm asking is how do I display the genre fo that particular movie?
I have one to many relationships between tables related with PersonID. From the entry forms I enter data and there is another form to search data. The data search form displays some 5 fields from different tables: first name, last name, phone, email...
Problem description When I enter new data in all the above named fields, then the search engine can find and display the new record. However, when I leave blank some of the fields, let's say, the phone field, then the search does not display the entire row, although the first and last name, for example, exist in the appropriate table.
I would appreciate, if anyone could help me to solve the problem.
I have a database which creates hyperlinks to a network folder full of images (too many to attach to the database) but I can't figure out an easy way to show those images in forms and reports. I think I'm 90% there, looking online I figured out that if i create a text field (not a hyperlink) in the original table and copy over the hyperlink text, I can use this as the control source of an image control (with the picture type set to 'linked').
That works fine, but I would still have to manually copy over the URL every time I link to a new picture - so is there a way i can get this to feed through automatically?I've tried a couple of ways already (calculated fields, 'set value' macros) but the problem is anytime I try to get clever, Access doubles the link address, making it utterly useless as a control source.
So for example, i ran a macro to set the text field value to equal the hyperlink value of c:mydocspicture.jpg, and the result looked like this c:mydocspicture.jpg#c:mydocspicture.jpg#Or maybe there are functions similar to excel (like 'left' and 'len') which i can use to extract the right part of the hyperlink.
