Hi
I have a form with buttons that I've found i the sample database.
When I click the buttons I get one of my forms in the destination window.
But the form doesn't link to the right link ID, is this something you can code?
Attached is the sample. (not with my form in though, but you get the picture)
Mikael
What is the best way to accomplish this? I have a database that split into the Front end and the Back end. The form that the users entering the information uses the queries from two sources. One is the a table within Access and the other is an excel spreadsheet that I link to it. How can I update /replace the Excel spreadsheet while users are using the form of the front End?
View 9 Replies View RelatedAs the DB is too big to put as an attachment i have attached the relationships.
I have a form 'Call next customer', based upon call details table. Within this the Customer ID field. I want to place a button on the form 'place an order for this customer' which would take them to an uncompleted order form but with the Customer ID already filled in.
I have managed to this to some extend but the button directs me to a completed from for that customer - a past order.
Any ideas? I will, around 6pm tonight (1 Feb '04) upload the database upon my website to view: www.lecoqsportif.co.uk
Thank you very much for your time.
Hiya
Please be gentle I am no expert at this sort off thing.....
Is there a way of clicking on a line in a table and the relavant form opens in a new window. You can then edit the form and the table is updated.
Thanks
Gibby
Hi there,
I have a question: Is it possible to link more than one table to the same Form in order to keep previous data?
Thanks a lot
Hi all,
I've got a little problem when users move through records on a form that has an image embedded the source of which changes for each record linked using a filename field and path in the database. The pictures are served across the network from another computer. Some of them are relatively large and take a second or so to load.
The problem comes when a user tries to browse too quickly through the records, when the pictures are importing a box appears advising the user, if the user clicks through too fast the box sticks and remains visible in the foreground right in the middle of the screen, it even remains when Access is exited. You have to end the process in Windows Task Manager in order to get it to disappear. I'm using Office XP with service pack 3, does anyone know of a fix for this bug
or if there's no fix
is there a way I could maybe delay each record by about 1 second to allow a picture to load as the user browses through using the record selectors at the bottom of the form?
Many thanks for any advise given.
Hi every body. i made a bounded data entry form that is based on a form and a sub form. But when i try to run it i get many errors. I be happy if some one help me how i link these two tables since draging the sub form to the form did not establish the reletion automatically! I be happy if some one teach me how to link form and sub form together. Below u can see the two query which is for the main form and sub form.thanks
http://i5.photobucket.com/albums/y180/method007/constraint.jpg =====> table reletionships pic
QTimeKeepingemployeno,name ==>query
Code:SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpNameFROM dbo_Employee;
subform query:
Code:SELECT dbo_Hours_worked.*, dbo_Task.descriptionFROM dbo_Hours_worked INNER JOIN dbo_Task ON dbo_Hours_worked.Task = dbo_Task.taskcode;
I am pretty sure the answer to this is no but I need to ask anyway.
Is there a way that your tables can be set up so clicking on a record will take you to the corresponding record on the form (like you can do in Filemaker). I have a client who doesn't want queries or reports set up (!!) just wants to be able to filter and search using the table and then link to the form...
I have developed a Microsoft Database Access 2010 Table and associated Form..I open both the Table and Form and a separate tab appears for each, then I can switch from either the table or form by clicking the tab.In the Table screen I select a record, as an example, record number 1926. How can I link this record with the form so that when I select the form tab, record 1926 is shown?
View 4 Replies View Relatedim creating a workers database and iam a beginner in access.i have created one table and a form like with the following details workers number ,name ,position attendancy and allowance so what i want is is i choose a workers number from the combo box all other details associated with the number should appear how do i do that?
View 6 Replies View RelatedHi,
Have been developing an Employee DB which includes sickness records and interview information. Have mangaged to sickness records but now I need to link interviews to these specific records which is where I am having a problem.
All sickness records are shown on a sub form and I attached a button at the end of each record so that I can can add interview information that is linked to the sick record through SickID but just cannot get it to work.
Have attached relevant forms and tables and could really do with some help as am pulling my hair out here.
Cheers
Hallo,
I'm quit new to Access.
I have an existing application. There is a form with some selection fields. When I press the button report then following is executed:
- The report object is called with DoCmd.OpenReport Rpt, acPreview
- This report has object dependencies with the query qryRptClient AND the form frmClient. This is the form with the selectia criteria.
The query "qryRptClient" has nested query's but in some of them, in the where clause fields are tested like: "WHERE (tblTempProject.country=forms!frmClientReq!cmbCoun try"
Generating of the report works correct ==> so far so good.!
Now the application must be extended by exporting this report result to XML file. So I have added on the form another button wich is calling the same query Like:
Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="qryRptClient", _
DataTarget:="c:Projecten estexports" & FileName
But now I get for every selection criteria field which is used in the query's a popup window asking what the value is of this form object.
So, I understand with the report that there is a link between the report, query and the form but in the second occassion how do I get a link between the query and the form.
Can somebody help me? Thanks in advance.
Nico.
P.s. When I try this with northwind database, with the query invoices, it working correct and I get a XML file! So the export on itself is working.
This form is bound to another table. Now i want to include a checkbox on this form that will be bound to an entirely different (small) table. How do i do this? :)
View 14 Replies View Relatedhi
i have a form just like customer orders in Northwind
with 2 subforms
Subform1 is showing orders number and i want to add something on that
subform 2 is products that ordered !
i want to add something on subform1 that if i Dbl Click on orderID field
it will sho for example another Form "orders"
i'm trying this code but i can't do it
Private Sub OrderID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "orders"
stLinkCriteria = "[OrderID]=" & "'" & Me![OrderID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit Sub
End Sub
would u please help me
I am new at this and have been struggling for days trying to solve this problem.
I created a database, using the wizard, to keep records of my orchids.
This resulted in a table. I keyed in the information on each plant.
Then I created a form, using the form wizard. Everything worked great. I could switch between the form and the table views.
The other day, the form no longer contained the information from each of my records. When I tried to switch to datasheet view (from form view), there was no longer a datasheet listed.
When I go directly to the datasheet (when starting Access), I can see all of the records (186 of them), but if I try to switch to form view - no form is listed.
Please help.
http://www.access-programmers.co.uk/...ad.php?t=97787
I am attempting to add a command button on a form that will allow user to browse files, then select a MS Project file to import, then have it linked to the current record (by a hyperlink or icon of some sort) so that clicking on it will open that MS Project file.
I found the above thread and have imported the modules and the fFindOpenImportFile in order to test in my database. I have made only slight alterations to the code, as I am still a novice w/ VB, but may not have done so correctly. In the Private Sub bImport_Click, I inserted 'tbFile' where sample "C:WindowsWin.ini" had previously been, so that it will import the file already selected from the bBrowse_Click. (If there is a cleaner/better way to do this, I would appreciate any help.)
Here is an exceprt from the code:
Private Sub bImport_Click()
On Error GoTo Err_bImport_Click
Me.tbHidden.SetFocus
If IsNull(tbFile) Or tbFile = "" Then
MsgBox "Please browse and select a valid file to import.", vbCritical, "Invalid File"
Else
If Dir(tbFile) <> "" Then
CurrentDb().Execute "DELETE * FROM tImport"
'FileCopy "C:WINNTWin.ini", "C:WINNTWin.txt"
DoCmd.TransferText acImportDelim, , "tImport", "tbFile", False
MsgBox "Your file has been imported into the Database."
Else
MsgBox "Your computer does not have a C:WindowsWin.ini file so the import example will not work.", vbInformation
End If
End If
Exit_bImport_Click:
Exit Sub
Err_bImport_Click:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_bImport_Click
End Sub
The imported form works great for 'Browse' or 'Open', but when I try 'Import', I get the following error:
2391- Field 'F1' doesn't exist in destination table 'tImport'
I even went back to the sample database and tested the form within the sample, using "win.ini" file and get the same error????:eek:
Of course, when I try it with an actual *.mpp file, I get this error:
31519- You cannot import this file.
...which leads me to believe that even if I fix the first error, I might be on the totally wrong path b/c it's an *.mpp file???:confused:
Any help would be greatly appreciated.
Thanks in advance for any help!
Hi,
I have set up a database for my company which holds records to all the companies that we have as clients. I have created a main form and a subform. The main form is where all the particulars of the companies are entered, and the subform is like a preview window of the companies. By right, when i click on one of the records in the subform, it should reflect in the main form, enabling me to add on additional information using the fields in the main form (i have some features in the main form that should be used to record the informatio), but I just do not know how to go about doing that. is there a way to link the subform to the main form, such that when i click on the past records in the subform, it will reflect on the main form for me to edit? Any help is appreciated.
Basically what I am trying to do is to link the crosstab query to a Form. the crosstab query has the following SQL:
TRANSFORM Sum(SubQryTotalProductSales.SumOfQtyOrdered) AS SumOfSumOfQtyOrdered
SELECT SubQryTotalProductSales.fkProductID, SubQryTotalProductSales.ProductName
FROM SubQryTotalProductSales
GROUP BY SubQryTotalProductSales.fkProductID, SubQryTotalProductSales.ProductName, SubQryTotalProductSales.YrOrder
ORDER BY SubQryTotalProductSales.YrOrder DESC
PIVOT SubQryTotalProductSales.YrOrder In ("2015","2014","2013","2012");
The Main form was made from my Product table and contains all the product related fields. ProductID, ProductName, Description, X_Ref, ListPrice, OurCost, fkSupplier, Discontinued, ReorderLevel etc....
Then I made a Subform with the crosstab query, and tried to place it in the main form. So far everything seemed to work. The next thing was to make the Child and Master Link, I used the fkProductID from Child (Subform), and the ProductID from Master. So there are no errors, but I don't get the link to work, that is when I change the product Field in the Master the Subform does not change accordingly.
When I change the view to design view and then change again to Form view, it opens up with the correct product in both Master and sub. Except in the Sub the productName Shows the productID instead of product Name.
Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
How to link additional data source to a form
Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
Hi Di Hi
I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread.
I have a Access Database and have a client page that stores all the information about that client. We produce reports (scanned word/pdf) for each client and we store the report files in a client folder using the Client ID taken from Access.
My question is can I somehow produce a link from the Client Form in Access to the Client Folder or Files in explorer. I have seen the Hyperlink option but that is only availabe in Design View.
Hope someone can help. Thanks in advance,.
I have a Datasheet view of a form and it displays a "+" symbol. When expanded it returns a list of related records. How do I get rid of the "+" in my form?
View 8 Replies View RelatedSee Attached Database
I created a form called cptSearch
On that form has a list box
What i want to do is when user clicks on cpt in list box and clicks on the edit command button it will open the frm called frmcpt so user can edit details for the specific cpt code
Any Ideas
:mad: and tearing out my hair with this one...
Someone out there please help:
I have a form that should open, linking to the date on another form (that is changeable using a Calendar Control), and display records for that date.
My underlying data is available for a variety of dates but some of the dates (and therefore the records) will not appear when this form opens.
They will all show if the form is opened without the filter. Or they will show in a report.
So I know that the coding is correct.
This intermittent-type thing is really bugging me.
Have even tried re-typing some of the dates in the table in case the format has somhow got changed.
Nothing is working.
(MS Access 2010)
I'm trying to find some code to allow a datasheet form to link to a csv file.I'd like the link to the data to be dynamic so it connects when the form loads as the access database will be run from a network share by multiple people at the same time.
The CSV file will be different for each user and reside on their local PCs in their profile folders.
I've been trying variations of this snippet of code I found which is called On Form Load:
Code:
Public Sub getData(path As String, fileName As String)
Dim cN As ADODB.Connection
Dim RS As ADODB.Recordset
Set c N = New ADODB.Connection
Set RS = New ADODB.Recordset
[code]...
setting up and connecting ADO data sources to a form.
I have a form (frmAddBeaterToShootDay) with a subform (frmChooseBeaters). I want the subform to show all the records of all the beaters in the contact list, which it does. I then want to be able to tick the box (AddToShootAsBeater) and associate that person with that record on the form (frmAddBeaterToShootDay).
When I go to the next record on the form (frmAddBeaterToShootDay) again I want to show all the beaters on the subform but all the tick boxes in (AddToShootAsBeater) should be blank until I tick the required ones.
I think I should be doing this as a Many to Many relationship which I have done from (tblContacts) (tblShootBeaters) (tblShootDates).
The problem is when I put all three tables in the query I get no results in the subform!