I got a combo box with a few columns for locating query activity. However, how can I make use of it to locate a particular record according to predefined values, for instance in a loop, to locate records. The combo box got 3 columns, just want to know the syntax to define the combo box according to some values. I need to define only the first colmun or all 3 columns??
View RepliesI am trying to locate a record on a multirecord form by using Findfirst method. Here is the code.
Dim UA1 As String, UAE1 As String, UA2 As String, UAE2 As String, UA3 As String, UAE3 As String, apost as string, repl as string
apost = "'"
repl = "''"
UA1 = Nz(Forms(ParName).Form.NAME, " ")
UAE1 = Replace(UA1, apost, repl)
[Code] ....
This code sometimes works and sometimes it does not work. The field CNO is a text field of 5 characters but contains the card numbers that is numeric data or nothing.
Me!ComboName.DefaultValue = Me!ComboName.ItemData(0)
this assigns the first value in the combo box to the default.
can this be changed to always assign the last possible record in the list as the default.
I have a database I took over, that generally uses linked tables to a MYSQL servers on another machine. The Access database uses a machine DSN to connect.
There are many queries that contain references to linked tables using another name. For example, the table is "service unit" but the queries are using "SU" as a reference. I cannot find any database object with that name SU. There are many such tables referenced like this - all uppercase letters, which is a common thing they all share.
Now, the server had a file integrity issue, and now the queries that contained the SU references will not work anymore. I created a linked table and called it SU and but the queries still won't work until I edit the queries, remove the old SU table, and add the new one in. So,
1. Where those table references could have come from, if it's not a linked table? Is there a hidden location on the server, or in the access database that stores another connection method?
2. Why won't simply adding a similarly named database object work the same way? Why must I re-edit all the queries?
I have built an example of a form that I am working on. My original design used the default record navigator bars that are setup when you use the wizard to create the form. I would like to remove those bars and use the linked combo boxes that I have placed onto the form instead.
My end all goal is to have those two record navigation bars completely gone from the form and have the combo boxes perform the same function they were used for.
I would like to keep the data entry portion of the form the same because I like the design and I like that I can limit it to data entry only so theres no chance that the users will accidentally modify existing data. However, if you have a different method of entering the data that will still provide me with the protection of "data entry only" that will be welcomed.
G'day. I've been browsing the forum trying to find a solution to a problem, without much luck, and am hoping that someone might be kind enough to help me more directly.
I'm a biologist and a newbie to access: with the distinction of being completely clueless about VBA. Nonetheless, I have been tasked with creating a database for storing data obtained from biological surveys of juvenile salmon and harvest/spawner surveys of adult salmon.
The bones of the db are in place and functional. The problem I have is streamlining the data entry process to minimise keystrokes/mouse clicks.
I have a subform for entering fish records with attributes such as 'species_name', 'fork_length', 'count', 'presence of tags, etc. The idea is that fish can be entered as individuals (count=1) or groups (count>1) with attribute data at the appropriate level (eg, fork lengths only entered for individuals. We typically measure the fork lengths of the first 20 individuals of each species and then tally the remainder).
One problem I face is that fish often occur in schools, and it becomes quite tiresome to click and select the same species_name combo box value for each record when entering multiple individuals of fish of the same species.
What I would like to do is set the default value for that combo box (on the fish subform) to match the value entered for the previous record.
I suspect that you could use the after update trigger to execute some code to change the default value each time something is entered manually into the combo box. Unfortunately, I know nothing about how to write the appropriate code.
Can anyone offer me some guidance?
Thanks in anticipation.
Sincerely,
Craig Dolphin
I want to take the sum of all records 'cost' i.e.
record 1 - 2
record 2 - 4
record 3 - 3
I want to take the sum and put it in a calculated field and use it to divide it by a predefined value 'no of responses.'
So I make the field in the query -> Calcfield: (Sum([cost])/[responses])
I am pretty new to this and i don't understand why this won't work? Is it something to do with the row Group by (total.)
I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will vastly reduce the amount of work and time spent entering records individually.
The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cells back from Excel and then paste this range back into the Access table.
This works but is long winded; what I would like to know is is there a simply way of achieving this.
I have an Access database. Now I want to export the data of a table in the database to excel sheet in pre-defined format. e.g. i want that in the first row of the excel file, there is a heading called "Report". In the second row, there should be column header like "Name", "Age", "Gender". Also there must be 1 column gap between this header. Then in the following rows, there should be data.
View 2 Replies View RelatedI have three tables: First, Second, and Third.The tables Second and Third each have a column with a default value of "X".I'm creating a query that selects fields from First table that JOIN with corresponding fields from Second and Third, so that all records from First are represented and only matching records from Second and Thirdare returned. I also select the "X" fields from Second and Third.
So I run the query: and the "X" column from Second only displays "X" for records that have a match in Second (since I mean for these fields to be quick indicators for if the record also appears in the other tables, this is my ideal result). However, the "X" column from Thirddisplays "X" for all rows, regardless of whether the record has a match in Third or not.
I can get more specific if need be, but I really can't tell why the one is displaying according to matching records but the other is always on. The JOINs are set correctly and the properties for the columns all check out.
Hi Everyone,
I hope someone can help.
I have a form with a combo boxes and a table with relevant list and additional field, fldDefaultDrive (Yes/No Field).
Currently in order to set the default value, I have used the following code for each default;
Private Sub Form_Load()
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """D"""
End Sub
However, I want users to be able to go into the table and change the default value if thier CD player default Drive is anything but D: Drive. I have tried to replace the D above with an SQL statement but with no success.
Private Sub Form_Load()
Dim Drivename As String
Drivename = SELECT tblMediaDrive.fldDrivename FROM tblMediaDrive WHERE (((tblMediaDrive.fldDefaultDrive)=-1));
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """Drivename"""
End Sub
This is definetly not working, can anybody help, I have a feeling it is syntax but not sure where? :confused:
Robert88
I have a subform containing a list of Funds and attributes such as Asset Type, Fund Manager, etc.
Currently, I have a textbox, where the the control source is set so that it will be updated with the Asset Type from the subform.
I also have an unbound combo box that contains a list of Asset Types queried from a table via row source, where user can select the Asset Type.
What I would like is when a record is selected from the subform, the Asset Type is selected on the combo box as a default value. User can select another Asset Type if required. How can I do this?
The problem I having is if I have a computer name of a computer on our network (not the one I am running the database on), is there a way using VBa to find the details about this machine.
For example if the computer name is 'DTP002133' I can click 'start' then 'search for files and folders' then click 'computers' in the search for other items. This search will give me the computer location and comments. I would like to be able to automate this process within my database.
Not sure if this one is possible but thought I'd pick you brains...
Thanks
I'm very new to Access and especially VBA. How to get started with the correct syntax for locating a file, and printing it. The file will be a PDF and if possible I would like to declare a variable for the file name (not the path) so if it is changed I can just change the variable instead of looking for it in the code. I plan to have 10 of these.
View 6 Replies View RelatedScenario: I have a combo box in an evaluation db that is set up to return 3 columns - EmpID, Name, JobID. The combo box only shows Name, but properly updates the neccessary fields on the screen.
Problem: I would like to turn the JobID txt box into a combo box that would default to null prior to a Name selection (on a new record) and then default to the recorded JobID after Name selection. 99.9% of the time, this won't be used, but occasionally an employee will receive an evaluation for a JobID they did, but were not officailly assigned.
The right way to do it would be to create a second record in the primary system that I am polling the data from, but that is not feasible given the nature of that system.
Any ideas?
-Brian.
Hi
I have an MS Access application which works fine until used with XP OS.
In XP if you open a report which is based on an ODBC linked table and try to send in RTF format as an attachement you get this error message:
MSACCESS.EXE - Unable to locate component
This application has failed to start because BJABLR32.dll was not found. Re-installing the application may fix this problem.
The error only occurs for reports using ODBC tables as a data source for which you need to enter an ID and password. Other reports can be sent normally using Outlook etc.
Anyone had any similar probs?
Thanks
Andy
In order to act as a system, I would like to have a function or windows firstly displayed all the folder names in a drive, and then allow user to locate/select freely a folder among different folders. Is there anything for my reference or for me to start??
View 4 Replies View RelatedI have a table that was linked from a SQL Server with a file DSN. It was linked years ago so now I want to locate that specific DSN file for that specific table if possible.
View 3 Replies View Relatedcan anyone tell me how i can have the default value of the combo box field as the first value in the combo box drop down list?
View 3 Replies View RelatedHi guys,
I'm obviously doing something stupid in my form :-) If you open the form in the attached sample you will see that I have 2 combo boxes. One of them has a default value showing and the other doesnt, I want to get the second combo to automatically show the value in the list but just cant seem to get this to work...
I cant work out whats different bewteen the two. Been tearing my hair out here so would appreciate some input.
Thanks in advance
Hi guys,
In my form I have a combo box that is bound to a product/specification table.
When clicked, this combo box displays a list of products, each with its respective set of specifications (although I configured it so just the product column can be seen.) The reason I do this, is so that the specification values (against which certain other values in the form is critiqued) will be a static value in the form itself, and not a changeable value in a table.
What I want to do, however, is to let the combo box assume a default value when the form load (it must already have a product selected at start-up.)
How can I do this?
Thanks ahead!
Hi all,
Can some one help me with how to set a default text on a combo box whose record source is set to a query?
I have a form with two combo boxes. The first combo box’s record source is set to the following query:
SELECT chrCategoryID, chrCategoryName
FROM tblGuarCategory;
My 2nd combo box will list all the items based the category I select on the first combo box.
But when the user opens the form, instead of showing both combo boxes blank, I would like to display the following text:
Combo Box1: Select a category
Combo Box2: Select an item…
I tried to use the combo box’s Default Value property like = “Select a category”. It didn’t work. I am not sure what is missing here. I appreciate your help.
I am sure this is a very basic problem but I just can't seem to make it work...
I have a form with a combo box. The values for the combo come from a table listing available month and year of various data. When the vlaue is selected in the combo box, the form refreshes the data to display that month and updates another table with that month that is used for a few different functions. Everything works great except that when you open the form, there is no value displayed in the combo box. What I would like for it to do is display the month that is equal to the value found in the second table, since that is considered to be the current month. I have tried various approaches to setting the default value and using a query in the control source but It still shows no value when opened. Any advice would be appreciated....
Hello,
I have a form with a combobox which has its record source to a table which has 5 records.
Is it possible to open the form so that by default the combo shows a specific record?
I have tried something like this but does not work:
On Open event
Me.Cbo = "ID"
ID is the record I need to show.
Thanks.
:confused: I was wondering if somebody can help with my default combo box problem?
I have a secured database whereby users logon, which is used as a scratch pad for keeping track of Purchase orders. A Form frmUserInput with two relevant fields for this problem 1. User Initials txtUsersInitials and 2. POBook (Purchase Order Book) which is the combo box cboPOBooks both unbound fields on the form.
The txtUsersInitials is generated automaitcally when the form is loaded using a VBA statement txtUsersInitials = Current User.
The list of the combo box is generated from a table tbleUsersPOBook and uses a query qryUsersDefaultPOBook as listed below;
SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[Forms]![frmUserInput]![txtUsersInitials]));
This generates a drop box showing the Different department codes for each individual. So for some it is only one item for others up to three codes, this part works fine... :)
:cool: However here is my problem.
Since some people can sign off more than one Purchase Order book I have had to add an additional field in the table tblUsersPOBook called DefaultUsersPOBook which is a yes/no field, so only one yes exists for each user who logs on. I have created another query qryDefaultPOBook as listed below;
SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[FORMS]![frmInputForm]![txtUsersInitials]) AND ((tblUsersPOBook.UsersPOBookDefault)=Yes));
When I place this query in the Default section of the combo box it gives me no result.
Firstly is it possible to have a varying default like this since each user will have a different default?
Or is there maybe a better way of achieving a default which is variable for each user based on thier default Purchase order book in the table tblUsersPOBook for the field "Yes" in DefaultUsersPOBook ? :confused:
I am trying to set the result of a query as the default value for a text or combo box. I have tried setting the query as the default value in the box's property. I have also tried doing it in VB. The code looks like this
Dim SQL AS String
SQL = "SELECT Address
FROM Table1
WHERE Name = Forms!Main_frm!name_lbx.Value;"
Forms!Address_frm!address_cbx.DefaultValue = SQL
I have also tried
Dim SQL AS String
SQL = DoCmd.OpenQuery([update address_qry])
Forms!Address_frm!address_cbx.Value = SQL
Where update address_qry is the same as the above.
I keep both forms. I know how to do it by setting the queries as values in a list box, then transfering the values to the text or combo boxes. But I was hoping there was an easier way.
Thanks
Alex