I been trying to figure out how to do this for some time now. But nobody seems to be able to know the method. I have searched the message board and tried the techniques that were suggested but none of them seem to work effective. Here is the problem:
All I want is a 2 textboxes on a form that where a user can put in the parameters for a query. The users clicks on the generate report button and the report pulls the textboxes's data as the parameters data. Report opens and its done. Every time I try this I get the query still asking for the parameters. Is there a sample database that someone can point me to that is using this method for the parameters. The Microsoft website has nothing pertaining to this matter. Only reason I am trying to use this is to stop people from putting in the wrong parameter information and it would look better then that generic parameter box that pops up.
I have a parameter form I used to enter data for a query. I want it to clear any previous data entered when it opens. I have tried the below without success. I also have the fields defaults set as "" and the form set at yes on data entry.
Private Sub Form_Open(Cancel As Integer) Me.BldgCmb.Value = "" Me.StateCmb.Value = "" Me.CityCmb.Value = "" Me.AddCmb.Value = "" End Sub
Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters:
1) Users import their data via an excel spreadsheet. Its all done behind the scenes. One routine pulls in information about servers from an excel spreadsheet and after formatting it via queries, puts it in the main table. The spreadsheet in question starts with the servername cell. On the spreadsheet, the first row contains the name of the server, but the second and subsequent rows contain blank space in the servername column, but imply that the rest of the information is for the various connections associated with that server listed above... IE:
Column "ServerName" Row1: Server1 IP address Switch Etc Row2: <blank> IP address Switch Etc Row3: Server2 IP address Switch Etc Row4: <blank> IP address Switch Etc Row5: <blank> IP address Switch Etc Row6: Server3 IP address Switch Etc and so on and so on...
What im wondering, is if its possible to fill in the blank spots with the cell above the records that start blank? (to populate the record with its respective server). Any input on methods to accomplish this would be appreciated.
2) Is there a way to attach code to the different buttons on the record selector? For tracking purposes, everything that my users do is stored in a seperate table. The only thing I cant seem to track is when users enter a record via the main data entry form. Automated tasks are no problem, but I cant seem to find a method to attach code to, say, the next record button on the default record selector.
3) I have a few queries that collectively import data from excel. When I do this, I remove confirmation messages so that users dont have to click through a sea of 'OK's. Im wondering if theres a way to count how many records get pulled in from an import, seperate which were good and which were bad, and simply pop up a message box stating that X records were imported succesfully, and X were not due to whatever reason.
4) Is there a way to sort text as if it were a number? I have a few fields that need to be text format, but contain numbers most of the time. The sorts always put 1 above 10, 9, 8, 7, etc, and id like to either find a way to make a query that changes all single digit numbers to double digit numbers or simply sort it in a numerical format.
5) What considerations should I take into account when it comes to the amount of data that access 2003 databases can effectively store and use? Ive heard that access can effectively handle 32000 records or something to that effect. Over that, what will I be dealing with? Slow performance? A complete roadblock?
I realize that there are a lot of questions here, and by no means wish to have my work done for me. Id very greatly appreciate any feedback that anyone wishes to give 8) Even if you dont want to code routines for me, thats fine.. I actually enjoy figuring this stuff out on my own, and a simple nudge in the right direction would suffice.
My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers. For instance, question 2 reads: "What location/time are you taking courses (select all that apply)"
and the possible answers are: 1)Daytime/Oakland 2)Evening/Oakland 3)Saturday College 4)BC
- Where a student could be taking classes at multiple locations or times. I am completely lost as to how to set this up. I have tried to set the properties for the field on the form to accept multiple responses, but of course, these do not save to the table and so it's completely useless.
I am in the process of creating a database in access to search for a persons name. However, the results will give many ansers. For example if I search for the srname 'jones' I get many names. I eed then to be able to select one of these jones's with the information relavent information.
It has many years since I have done this although i did have quite a good knowledge at the time. Plesae can you make any suggestions and answers as basic as possible !
Many thanks in advance http://forums.aspfree.com/newthread.php?do=newthread&f=18# Mad
I just have a question, is there anyway to create a standalone ms access 2003 file. I want to be able to create a ms access db that has forms and certain reports.
I have a client who needs this ms access file to distributable to his clients (who can use it without having ms access file). Also he him self can make changes, to the forms, etc. Without any programming knowledge, change the look of the forms, add queries, etc. And be able to send the updated version of the ms access file to his cleint.
Can this be done? I have suggested using a vb frontend & and ms access as a backend, but he would have to pay someone to make changes, add reports, etc. And he wouldn't be able to do it him self becuase of lack of programming knowledge, he only has medium knowledgable of Ms Access.
At work I have been tasked with a few Access based problems and one of which is making one of their handwritten feedback forms be input on Access so then responses can be graphed and analysed.
Is it possible to give written answers a number so they can be graphed.
For example.
Question 1 - Give me an example questions?
Answers:
1. Yes 2. No 3. Unsure
So you can see how many have each one when you graph the results. As I have it created with foreign keys at the moment it is displaying the text when I do the queries.
Also... is it possible to make a button so an interactive pdf report can be sent to all the selected user's email addresses?
I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.
What is the best way to go about doing this? I use Access 2010
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
I'm having some trouble with a report I am responsible for. I'm novice to Access, so if you could please explain in detail...that would be great.
Well, I am supposed to create a report, that will pickup data from 1 table (Passport_details), and display them in a report. Within the passport Details table, there are 3 fields (Scrap, Resale and RTS). For each record, their will only be a number in one of these fields. For example:
Product status: **here is where Scrap, Resale or RTS goes" PassportID Product Scrap Resale RTS 123456 Battery 9 0 0 987654 Pots 0 7 0 456789 Knives 0 0 3
What I want is a textbox or label at the top that will state "Scrap" if there's a value other than 0 in the Scrap Field....."Resale" if there's a value other than a 0 in the Resale Field, and "RTS" if there's a value other than a 0 in the RTS field. There isnt occurences where their may be a value for two of Scrap, Resale or RTS...its either one of them.
I'm sure this is simple for the experts within this forum, but I could sure use the help.
I need a text box in a form to display a series of error messages depending on the result of a DateDiff result, but I'm having trouble creating a single formula that encapsulates all error messages, but I have been able to get this working easily enough using 3 text boxes (For 3 seperate error messages one for results between 7 and 13 days, another for between 14 and 27 days and a third for 28+ days) and the same basic formula, I just need help combining them into a single formula for a single text box. I'm using these:
=IIf([DateDiff]>=7<14 and [Bleh] is Null, "7 Day Warning", "") =IIf([DateDiff]>=14<27 and [Bleh] is Null, "14 Day Warning", "") =IIf([DateDiff]>=28 and [Bleh] is Null, "28 Day Warning", "")
How would one go about combining all those formula's? I tried for ages today but I didn't come up with much, experimenting with Or IIf etc... but coming up with -1's all the time. Any help would be appreciated
OK, this is my first post and unfortunatly it is for some help...
I have searched Google to my wits end without any luck.
Heres my problem (partially) and I am hoping some kind person can help me.
Suppose I have a form [form1] and a query [query1].
On form1 I have a 2 textboxes. [txtProduct] and [txtStockCount].
Into [txtProduct] I enter the name of a product. In reality I have already a usable listbox in my form, but I am using a textbox for simplicity here!
Now I create an [EventProcedure] using 'On Lost Focus' against [txtProduct].
The event prodedure would partially read:
"SELECT query1.StockTotal, query1.Product FROM query1 WHERE = Product = txtProduct;"
In my actual form I am using a listbox with a listbox.rowsource = (SQL Query)to display the stock count, but I don't think this is the best way... (It works, i'll give it that!).
What I would ideally like to do is take the results from that aformentioned query and display them in txtStockCount.
What I am aiming for is to get the a query to dump its single result into a variable; not just for display purposes (txtStockCount), but to later validate user input when they wish to reduce stock values from the database, IE so they cannot produce negative stock counts.
I have a feeling this might involve Record Sets which I know nothing about at present.
If someone could either provide some working sample code snippet or point me in the right direction I would appreciate it.
I am confident enough to write SQL statements. I am semi confident in using VBA. (I am not a complete newbie).
If I have not been clear enough, I can provide a lot more information using actual details from the database I am trying to develop.
The database is a stock control system which records:
* products in one table * transactions in another table (goods in and goods out) * a query to 'sum' up 'goods' in and 'goods out' with an expression to create total stock counts for each item * a form into which a user can select an item from the product table which would then produce a single count of the stock running another SQL query against the one already created to pick out that single product (phew!)
and finally in the same form add to the transaction table.
I would like to use code to look at each field in my form (they are all textboxes) and if it is blank, fill it with "888". I have read enough to know I should use the NZ function, but can someone tell me how it should be written to look through every textbox on the form?
This is maybe a question that has been asked a million times.
Can anyone explain me how you can link to textboxes in a access form. I'm making a form that input info. When a user selects a number in the first textbox I want that in het second text box the info of that number is showed automatically. Those two (number and info) are in the same table. And is this possible without using visual basic for applications?
I have a table with names of people and the cars they own. I made a form with a combobox which everytime i choose the name of the person in my combobox, it will list the cars they owned. That works fine. Problem i have is that i have to show how many cars they own. So i made a query to count the number of cars for each person. Then I made a textbox on the form to show this count. However I can't seem to link this textbox to the query since my form has a record source to the table of ppl and cars. How do i link my textbox to my query of counts of cars?
I tried changing the control source pointing to the field of the query but it doesn't work. I have linked the combobox selection so that my query filters to wat i select on the form. Anyone can help :( , its a simple process but i keep trying and doesn't work, and also dont wanna use a subform.
i have a query which returns n number of rows. my problem is that i need to display the values in text box which is created automatically according to the number of rows returned in the same page(form).
for example if my query returns 1 row then 1 text box must be automatically created and then the value must be displayed and if my query returns 3 rows then 3 text boxes must be created and then the corresponding three values must be displayed.(on the same page).
I have a couple textboxes (Standard) format with 2 decimal places. The textbox allows me to enter say 12.65
What I wan to do is enter 12.65 in one text box and 43.56 in another textbox and then when I click on the third it multiplys the two above and places it in the third mentioned textbox.
I have that working to a certian extent...I place a number in Textbox 1 and then another in Textbox 2, then when I click on the 3rd one (After update event fires) and multiplys then giving me (see below)
hey all i was wondering, can a unbound text box be a bound textbox. I have just noticed that my unbound text box doesnt not save in the field in my table, that is because it is unboune right? but i need it to save to my table, and i guees the only way to do that is to save in in the save button right? thanks
hey all i was wondering, can a unbound text box be a bound textbox. I have just noticed that my unbound text box doesnt not save in the field in my table, that is because it is unboune right? but i need it to save to my table, and i guees the only way to do that is to save in in the save button right? thanks
I have a Form/subform that is used to allow editing of a user selected record from a table called personnel. When the form/subform is first opened, all text boxes are blank. The user selects the desired record from a combo box that uses a dropdown list to display all records of the table. When a record is selected, the contents of that record are displayed in the subform in which the user can then edit/modify. The user then clicks on a "save button" which then saves the record.
I want to use a msgbox that will notify the user that he has just updated a record and ask if he/she would like to update another record. If the answer is NO, then close form/subform. If answer is YES, I would like to clear the combo box and the subform text boxes. then the user can them start the process over by selecting the desired record from the combo box.
When I placed the msgbox coding into the "save" button's on click property, the NO portion worked fine. However, when YES is selected, the combo box would clear but the subform texboxes still show the previous record data (does not clear).
Can anyone provide some assistance?
Here is the code for the main form:
Sub SetFilter()
Dim LSQL As String
LSQL = "select * from personnel" LSQL = LSQL & " where last = '" & cboSelected & "'"
Form_Editpersonnel_sub.RecordSource = LSQL
End Sub
Private Sub cboSelected_AfterUpdate()
'Call subroutine to set filter based on selected last name SetFilter
End Sub
Private Sub Form_Open(Cancel As Integer)
'Call subroutine to set filter based on selected last name SetFilter
End Sub
Here is the code for the subform "save" button:
Private Sub SAVE_Click() On Error GoTo Err_SAVE_Click
DoCmd.RunCommand acCmdSaveRecord DoCmd.close If MsgBox("You have updated information on a Detachment Member. Do you wish to update another member?", vbExclamation + vbYesNo + vbDefaultButton2, "WARNING") = vbNo Then DoCmd.OpenForm "PERSONNEL MANAGEMENT" Else DoCmd.close DoCmd.OpenForm "Edit personnel" End If
