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:
these are two issues that are making some problems to me.in a few words i will make a description.there is a html that contains data.this data is updateable.i have made a link to my excel.i need to add somethings before they come to access.i have made a link in an access getting all data in it.i have made a update query to store data in another table so i will not lose previous data.all excel and access work opened.so at start it works fine.after 1-2 hours or maybe more a alert display and eather there is lost connection or it says that another user is using the data or about permissions.i then have to restart my pc so it can work again.all is working on windows xpsp2 and office 2003. please send reply if anyone knows something.thank you.
Hi I have lost a link for a great website that had online video tutorials in Access. It was pitbull or bulldog or something like that (tried all the combinations in google) Jog anybody’s memory for a url
I searched this forum just for "treeview" and on the 2nd or 3rd page I found a post with a link for some lessons on treeview. Part 1 was to make a treeview with the word Hello. Part 2 was for another lesson on treeview.Tried to find that link again and for the life of my I'm unable to find it.
Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example) to to enter a new one (which would then be added to tblBillingAddresses).
What I would like to have is a dropdown menu that automatically generates all the billing addresses we have (just company name, short address) so the end user can simply select the address as opposed to having to look up the auto number attached to it.
What would be better would be to be able to use have an independent lookup that classifies each billingaddress as MgmtCompany or SingleCompany, and have the aforementioed dropdown menu only generate those BillingAddresses that are infact Mgmt Companies.
How would you reccomend I go about doing this WITHOUT having to manually enter a new mgmt company to the dropdown menu each time we enter into business with such a company (I need a real-time search query based on the above criteria, in a dropdown menu within our contract From.)
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.
I created a query that shows everyone who has a specific date field blank. Now want to make those names clickable so that it opens a specific form with a certain record related to that individual in the query. Each line with a different individual should open a different person on the form and their corresponding record.
I recently moved by database from one hard drive to another - all is working ok after refreshing the links. However I have a few queries and reports that are date or date/time specific. (ie; I input a specific start / end date or start/end hour) Now when I run these queries it returns an error message stating 'Data type mismatch in criteria expression'
Please does anyone know why and how can I restore the queries ? Prior to the move all queries / reports worked OK.
Hi .. I have a lot of forms in my database. This database is already half way complete. I was not able to edit the data in the so I unlocked all the forms and allowed it to be edited, deleted and all those data related stuffs. but I realised that making these changes makes all the data in the form lost. All these forms are related but the data is only lost to those froms in which I make changes. What should I do so that I dont lose the data and still I can work with the forms
Today my Access database at work evidently burped! Now when I click on the Form that I want to open nothing happens! The Table still exists with info in it and the Reports still are there but the Form does not open at all. Thanks for your help.
I have a database with a huge table on the back-end, and then I want to set up various front-ends that will only show particular records that a user is interested in.
I notice that, when I query the big table without any join, I get all the records and also a space for entering a new record--that's what I want. But, when I add a join that serves to filter the records to the ones the particular user would be interested in, the space for entering a new record goes away. This is the case whether I view the query itself, or the form that uses the query.
Does anyone know how I can keep the ability to add new records while also making the query a bit more complex?
We have a small business and i do all the admin. I've created a database of all our contacts (name, address, phone number, fax number, etc) and i've managed to create a form that allows me to enter the data into that instead of directly into the database window.
The last thing i want to do is create a search form or add a button to my existing data entry form that will allow me to type in a contacts name, address, or any other thing about them i remember at the time, and be taken straight to that entry. Once this is done that is all i need to know for the moment.
I've tried an example i found on microsoft's site but can't get it to work properly.
Can anybody help. I'd imagine this is very very simple but i can not get the answer myself.
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?
As 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
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)
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?
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
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?
im 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?