I have made a query for each column in my table in order to sort by ascending order. I want to assign this Query to a column heading button on my form. What is the code, or how do I go about assiging this query to this button so every time it is clicked the data is sorted according to what that query says?
View RepliesHi guys, back on the development trail!!
I have a database, the 3 tables of current interest are:
tblStaticIP (IP)
tblComputerIPAllocation (ID - IP - ComputerID)
tblHardwareIPAllocation (ID - IP - HardwareID)
Realtionship via IP (no RI enforced).
I would like to be able to list all allocated IP's in a single query, even better prevent allocation of IP's allocated elsewhere?
Can anyone advise?
Thanks,
Phil.
I'm trying to create a table that shows only records assigned to the user based on their environ("username"). I tried creating a code that adds the user name to a table, but this won't work as multiple people will be using the database at once.
View 2 Replies View RelatedI am trying to use =DCount() on a report and its half way working, it does count records acording to the criteria I asign the problem is its using the whole universe of records in the table so I have a report displaying 10 records of which 953 are Red and 752 are Blue...
View 14 Replies View RelatedI am using a form based on a table in MS Access 2010 for data entry.
The Data Type for column ID is AutoNumber with Increment=1. When I found ID for recent entries gets an anomaly (e.g. should be ... 3, 4, 5 ..., but it shows ... 3, 5, 6 ... that misses 4), I tried to refresh/change the ID column with the following steps:
1). Change the Data Type for column ID from AutoNumber to Number
2). Add a new column IDD and set its Data Type as AutoNumber
3). Delete the original column ID
4). Change column name IDD into column name ID
However, I got a problem with step 2): here the order # for the records becomes messed up, e.g.
Should be:
ID IDD
1 1
2 2
3 3
5 4
6 5
7 6
... ...
But, I got:
ID IDD
1 3
2 4
3 5
5 1
6 2
7 6
... ...
Why? Is this caused by the relationships between this table and other tables?
I need to send email with attachment on click of a button. We use emails like name@basepost.biz which is assigned to gmail.I tried the following code but it throws transport to server error.
Dim cdoConfig
Dim msgOne
Set cdoConfig = CreateObject("CDO.Configuration")
With cdoConfig.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
[code]...
I am trying to create a training matrix in which i need a form that if I put or assign maximum of 20 attendees then 20 comboxes will appear in form.for example, i enter in textbox1 6 or 15 depends but max is 20 then if hit enter comboxes will appear but quantity will based on value that i enter in textbox1.
View 4 Replies View RelatedI have a simple SELECT CASE query. I'm not sure how the syntax goes and I want to learn about it.
In the attached file, if you click on "cohort table", you will see the categorization for each unit under "field1".
how will I be able to use a SELECT CASE statement in a query to populate each unit with assigned category?
I want to filter out all of the "Not assigned" so that it only displays the numbers in the field.
View 1 Replies View RelatedOn my form I have a number of buttons named A1 to A6. I want to be able to click on a button and bring up a report that thows all records A6 if that is the button I have pressed or A1 if that is the button I have pressed. I know I could make each query individually, each one looking for the appropriate data, but I was hoping I could make one query and have the criteria change automatically depending on the button that I press.
Is this possible or am I asking a little to much of Access!
Regards:)
Hello! I have some datums that I want to pass to a simple SQL query to insert into a table. It is basically just some text fields, and I just want to pu them into a simpel query like below by pressing a button.... but I am not sure on how to do this. Could someone please help :D
INSERT INTO tbl_orders (id_user, id_product, quantity, date_ordered, item_price )
VALUES (MYVALUE, MYVALUE, MYVALUE, MYVALUE, MYVALUE);
“frm_ENTRY” is showing info from “tbl_ESKER_IMPORT_TEMP”
I want to add a button to “frm_ENTRY” called “ACCEPT” that will run the query “qry_TRANSFER” to send a copy of the data to the table “tbl_TESTS”
I then want it to check off the [COMPLETE] field in “tbl_ESKER_IMPORT_TEMP” so that record will not show up again in the form. (I might need to make an update query to check the box???)
Basically the info in the TEMP table is coming in from an outside source. It usually has a lot of errors so I want my guys to review it, make any changes, then ACCEPT it into our main table. (tbl_TESTS) So my user opens the form, sees one record, makes changes, clicks accept, then it runs the append query to update the record to our table then updates it as complete.
Thank you to anyone who will help. I am sure it will be easy for you guys. Thanks.
I am building a database, that includes a subform (which is a query) and a bunch of text boxes that let you search the query. With these text boxes I'd also like to be able to add records on the table the query collects the data from. As in, you type into the text boxes above the data needed, then push the big red add button and it'd add a record with all the information you just included into the database; and you can see it below and search for it etc.
View 5 Replies View RelatedG'day all
I want to create a form that will be the layout of my storage warehouse. I actualy have a layout on paper but was thinking of doing it on a form for the users to have a better view. The location of the inside warehouse have 60 location or Bin. The outside one has 80 Bins.
This will need 2 query. 1 for the inside Bins and 1 for the outside Bins. They are both the same query except for the caption of each command button.
What will be the beast way to create the query as to the criteria is to read from thee caption of the command button.
If the caption is 50 then give me everything in 50.
Hope this make since.
Thanks you so much.
JP
Hello,
How would I go about in making a command button bring up a report to show a result of items for the end of the month?
For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the query as for months have different lengths e.g. 28/29/30/31 days. How would I make a query show the end result for each month correct as February if going to be different each time i.e. when it is a leap year. I have got far but having trouble with this part.
Hope you can help.
I currently export a select query as a .dbf file to a particular location and file name. I would like to automate this procedure to a command button on click event. Does anyone know the code to do this or have another way for me to do this automatically? It would even be better if I could export this same Query to Crystal Report automatically.
Thanks for the help!
Hello,
I have a delete query in my database which I would like to run from a command button on a switchboard. When I use the command button wizard, it does not show delete queries in the menu of available queries. If I create a command button manually I will need VBA code for the event procedure.
Can someone give me an appropriate code for running a delete query with a command button?
Thanks
Hi,
I have a query that is run off a form. When the query opens up there is a field you can enter data into. Once you close the query the data saves into the proper place in the table. That all works great.
I'm trying to make this as user friendly as possible. Instead of having someone go up to the "x" in the top right hand corner to close the query can I place a command button in the query that is very noticeable?
Any thoughts are most welcome
Thanks
Eddie.
Hi,
The query for my form has a boolean field with ' like "No" ' in the criteria. I want users to be able to use a command button to change this to ' like "Yes" ' then requery the form.
Basically, what I want to do is toggle between current records ("No" in the boolean) and Archived Records ("Yes" in the boolean).
Any ideas?
Regards,
I know how to filter my form so I get the records from a certain query by clicking Advanced>Filter by Form>Load From Query>Selecting the query I want> Toggle filter. What I want is a button that will do this just by clicking it. By default I have set my form to load a blank record. I also have a button to filter by an exact ID number. What I can't figure out is how to write the expression/macro to acheive this on my "Unprocessed button". The red button is the one I need to apply my query to.
View 14 Replies View RelatedI have a query: qryNoSurgery with linked tables tblSurgery(many) to tblPatients(one) where tblSurgery!SurgeryDate criteria = Is Null. When I run the query by itself, it works perfectly. I get all the tblPatients data where SurgeryDate field is null.
I created a command button that opens a form, frmPatients, If I enter qryNoSurgery as the filter argument in the embedded macro and run it, I get a Msgbox which wants me to enter a parameter for qryNoSurgery!SugergyDate.
I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.
SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.
I have changed the Form properties so that Data Entry and all the "Allows" are set to No...
Hi!
I'm having problems making a command button(Ta bort från engelska till svenska) of a delete query.
The name of the query is"Ta bort från engelska till svenska", which is also the name of the button on the form(huvudformulär)
Could someone please help me.
I'll enclose my zipped database.
Nille
Hello all
i need to create a text field and button in a form that will show all the records for a particular JobNo in a report once the txt has been typed and the button is clicked, i.e if I type JobNo001 I need to to create a report showing all the information for that JobNo(but there can be multiple JobNo's).
Do i have to create a query for this. I am new to this so please be gentle
Thanks
Chris
i have created a form that has data in a field as a referance, i want to use that ref to open a page or PDF file to that referance ,
The idea is that the form is the data input for hard copy documents, i will scan the documents and store them on a hard drive i then want to open the documents as word, or PDF files from the form to the ref of the field in that form
can anyone help
Hi
I'm not sure if this is a dumb question or not but is it possible for me to have a button on a form that will open the Query Builder?
I have a form that has 3 buttons on it - 1 to access records, 1 to access reports and another which I would like to open the Query Builder when clicked. The database will be used by beginners so I've hidden the design view button and also the database window which appears at startup. All that appears when I open my database is the 3-button form which is what I want.
I thought maybe I could save a blank query and then create a macro to open that whenever the button was clicked and stipulate in the macro to change the view to design view but that didn't work.
Thanks to any help or advice anyone can give and sorry if it turns out to be a really stupid simple solution I've missed (I'm good at that!)