I'm relatively new to Access programming, so I am mostly at a loss as to what methods, whether by query or VBA code, to do this. I am building a patient log for medical interns, so that the individual entries would include information of an individual visit to a patient. Part of this would include a function where I could, at one click, create a new record for the specific patient with fields such as patient ID, name, etc already filled in, with the values coming from the record that was open at the time, a sort of "dynamic default" value. I still want to be able to create blank records with the default ">*" button at the bottom of the form, so ideally this would be a new function. Would this be a relatively straightforward task, and if so, could someone give me some basic pointers to it? I'm in the process of reading some VBA self-help books, but have yet to figure it out. I have some experience in C++, so if I were to take the VBA approach, all I would need are the variable names and how to call/access them, and I should be able to knock together a working draft that way. Thanks in advance to all.
I have two records for a list of employees: start date and end date. I want to create a query for the top 5 employees who have been employed the longest (and are still currently employed, so end date should not exist for the top 5). How should I go about this using a top values property? thanks.
I have several tables but lets focus on two Table1 and Table2
Table1.ID is a foriegn key in Table2.NewID
I want the default value for Table2.NewID to be the MAX of Table1.ID; that is I want Table2.NewID to auto default/select whatever is the highest ID of Table1.ID. I have toyed with this as much as I can by entering different SQL statements in the the default field of the datasheet. And by defining different Macros for OnFocus event.
Welcome, i am making a database project for manufacturing purpose. I have made tables in MS Access and connected them with MySQL (ODBC). I have created data access pages for employee to access data to database. I have copied these page to my locale appache server and it works as a web page. I could(employee) insert data from a web page to MySQL tables, but now I want to make some reports and templates(made in Access!) be accesible from web page for managers. Graphs made in access too.
I will look like this: User will log in on a web site, when he log in as a manager there will be available reports and graphs(data from MySQL) that I made in Access. Data Access pages made in MS access <2007 work perfectly, can I make the same thing with reports, graphs, templates? I mean save them as a dynamic web page with links to databace?
There are a number of what I call reference tables. These are fairly static and in the main will not change.
There are a further half a dozen tables all linked together.
The system basically takes an enquiry which may lead to a repair taking place. The repair will have a number of jobs and each job may have parts replaced.
What I want to do is have an identical database which to begin with will have exact copies of all the reference tables. The remaining half a dozen tables initially will be empty but grow with time.
The user wants to be able to copy the completed repairs he selects over to the 2nd database (which is initially empty). As weeks go by he wants to select further completed jobs that have not already been copied over to the 2nd database. The 2nd database will be updated so I can't just copy over all completed repairs each time.
I had envisage him doing this by using a front end to the 2 databases and firstly selecting which of the completed jobs which haven't been copied over. This is a fairly straight forward query that will update a field on the repair table.
Once he has done this I was thinking that I could run a query that would pull all the rows from the 6 tables from database 1 and update the corresponding tables/rows on the 2nd database.
I don't actually know how to approach that. The process needs to be simple for the user. ie 1. select repairs to copy over 2. run something to copy them over.
I am using access 2010 and am trying to create a dynamic search like the one google uses, it will feature a drop down that will populate with results but when its not in use the drop down is not shown.
I'm looking to add a menu system to the form its self so that the users will be able to do certain functions. third image is what I'm looking to create with the menu bar at the top of the screen.
creating dynamic RibbonXML where statement will depend on user that is accessing access database. I created DynamicXML no problem and it changes context depending on user but my main problem is refreshing ribbon. I see that UsysRibbons tables changes fine but it's not being loaded. I have to restart access in order to this to take effect. I tried gobjRibbon.Invalidate method but it doesn't refresh ribbon for some reason... Here is my code:I created new module with name "Ribbon" and put this in there:
Option Compare Database Option Explicit Public gobjRibbon As IRibbonUI Public Sub CallbackOnLoad(Ribbon As IRibbonUI) ' Callbackname in XML File "onLoad" Set gobjRibbon = Ribbon End Sub
and then in form that validates a user I put:
If (Not gobjRibbon Is Nothing) Then gobjRibbon.Invalidate End If
In Access 2010 I have a Data Entry Form on which I have an unbound textbox in the header that the user can put a default date in. In the body of the form is a bound textbox that records the date and the default value is set as =defaultdatestat (obviously the name of the box in the header).
Problem: The default date shows up perfectly until a value is put in any of the other text boxes.
For further info : If you put values in text boxes default value disappears; if you then push escape the default value reappears when the values in the text boxes disappear.
Now that i have read this again, i think it could be summed up into one question...if i have a form based off a query with an outer join that has various duplicate records, is there a way to use the recordset in an if statement that says something like if this recordID = that recordID then dont show one of them...hence not showing the duplicate field data in the form.If you want a more specific description of the problem, read on, otherwise don't read on.Hi All,So I hope I can explain this ok....here goes....I have a search using dynamic queries: I have a form where the user can put in various information he wants to search to find a record. In this case it is searching for Hotels. So the user can search a country to see all of the hotels in that country. Also, the user can search an interest like Beach or Nature to see those hotels that apply. Obviously each hotel may have more than one interest so I have a 1-many relationship with a table called Hotels_Interests.The kicker, and you can likely already see why, is that the user does not have to fill out every search field. He may search Country&Interest, or just one or the other, or leave everything blank to see all hotels in the database. The results are simply ordered by HotelID or something like that in a form that is based off the dynamic query. The dynamic query is of course just based off the query i explained, but with criteria added in.The problem is with the query that i am basing this search off of. Right now it has the main Hotels table as well as the 1-Many table Hotels_Interests and even another that is 1-Many Hotels_HotelTypes (say All Inclusive, Resort, etc.). So this query has various 1-Many tables as well as the main Hotels. Now, if i fill in all of those fields in the search form, there will obviously not be any duplicates returned, which is super. But if i leave Hotel_HotelTypes search field blank, i will be returned with the same hotel twice or more times, which is my problem, because i want nice search results.I have heard of people using Union queries to get rid of duplicates but this obviously does not solve my problem as i do not want to just get rid of these entries. What i think i want is some VBA method or whatever of showing in my search results each HotelID that meets the search criteria only one time.Right now i have it working with If statements that say if the user has left a specific search criteria blank then base the search off a different query. This is obviously crazy and is only a temp fix. Now that i want three or more 1-many tables in my query, i would be talking about if statements for like 6 or more queries, insane.I apologize for the length of this, but i wanted to be perfectly clear. I feel like it should be not too hard, like using a record set for the form and not showing certain records or something, but i am not sure how to do it.Thanks so much. Dillon
Hello everybody! i want to create a table consisting of 2 columns. one column may contain constant values and the other has to contain dynamic values (values of the second column must depend on the values of the first column). For example if the constant of the first column is ID then the variable of the second column will be ID+5. Something like that below
I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record.
Is it possible to make the default values of a table with symbols in it?
I have a database that returns results with pictures and links included. What Im trying to do is make it as quick as possible to enter information, i've got the ASP page returning everything correctly but I still have to copy n paste certain things onto every form entry in the database.
These are all the things I couldn't get into the ASP code on the page. When i enter data I just have to flick back a page, copy, flick forward and paste for every section that has symbols (theres about 7 of em)...... gets a bit annoying after only 5 pages.
I hope thats enough info and not too confusing. Thanks to anyone that can help.
Hi all, This is my first post, i can't find the answer to my question anywhere so hopefully someone out there can help.
Is it possible to make the default values of a table with symbols in it?
I have a database that returns results with pictures and links included. What Im trying to do is make it as quick as possible to enter information, i've got the ASP page returning everything correctly but I still have to copy n paste certain things onto every form entry.
Tese are all the things I couldn't get into the ASP code on the page. I just have to flick back a page, copy, flick forward and paste...... gets a bit annoying after only 5 pages.
I hope thats enough info and not too confusing. Thanks to anyone that can help.
Hi The database is all about an athletics league, and i have set up a form for a query that i have made. When I open the form, i get the parameter box asking me which Venue ID i would like to choose, now what i would like is, whatever i type into that box to become the default value in one of the fields in the form.
I created a db for my property owners association. I have created a formula that adds up each year, but it won't let me do that unless I put in 0.00 for the blank fields. I was wondering if anybody could let me know if there is anyway that I can have 0.00 placed in the field so that my formula will work.
I have a form that when the user clicks a button a record is transferred to a new table/form. In the new form there are some extra fields that need to have default values in them. I tried setting the default values in the properties menu but that only works when creating a new record. Is there a way to have default values come up on a transferred record?
On a form I have text box named ImageVersion, and it has a default value of AO-02.17.06. It is likely that the image version's will be updated, it would be helpful if the user could change the default value currently set. Right now, I can do this temporarily, but it does not stay once the form is closed. If the form is closed, then opened, it reverts to the original default value set. I am not using a split database. I have it setup on a server, and users access it through there. Any suggestions?
Hi, in my database I have a 7 subforms that shows fields for daily tasks for each day of the week. On the Monday, the tasks are assigned and then stored for every record for the corresponding date. The process is done again on tuesday, then wednesday etc. However, often the daily tasks for say tuesday will be very similar (sometimes the same) to that of monday's.
Therefore is there a way to set the default values for each day as the previous days tasks and then alter them if needed?
I am currently attempting to use SQL in Access to alter a table by adding a new attribute and giving it a default value. Creating the attribute is fine but i keep getting an error when attempting to assign a default value. My code is as follows:
ALTER TABLE Objects ADD Status Text DEFAULT 'Object is Currently In';
I am hoping to create form that will prompt the user to enter default values for certain fields ie Week No and WB Date before allowing any data to be input into the form.
This may be more a VBA question than a forms question.
I have a main form and a subform. The suform contains several fields and there are several records on it for any given record on the main form.
I also have a command button on the main form that creates a new record. I would like to have the default records to disply be based on the values from the previous subform.
I don't know if that is clear. An example the main form would contain a location and date and the subform would have sales figures for Tom, Jane and George for items a, b, and c. Tom, Jane and George would be records and a, b and c would be fields.
Generally a weeks worth of data would be entered and generally new values would be added for the same group of records from one day to the next for any given week, however, there might be times when more or less records were entered.
I would like to set it up so that the subform is populated with the same records as are in the subform before the command button is pressed to create a new record on the main form. For instance if on day one items sold are entered for Tom and Jane when a new record is created it would display Tom and Jane on the subform with blank values for items sold.
I thought I could use min or max to get a default value, but, the table that the values go into is by date so max might get the value for Tom but not Jane and George (I think).
I preface this question as most newbies do. I have just started using Access(2000) and have built rebuilt/converted from DOS a database for a basketball club. I did start from scratch and just inported the table data.
I have already made a number of forms and subforms, e.g. searching for a player displays all the other players in that team and displays the team staff from the relevant tables. So I understands the concepts.
What I have tried to do, and succeeded in part is to populate some of the fields of the Player Account records from the Fees table. I managed to do a query from the Fees table for this using a drop down for the FeeCode, which fills in the Fee Description and Fee Amount. However if I change the Fee Amount it changes all of the fee amounts for that Fee Code type. (I think I solved this myself as it is a query and that is what it should do, correct me if I am wrong). Note that all of the retrieved data is static except for the Fee Payment, which can be different amounts, this is where it changes the source. Also as it is a query I think , the retrieved data just shows on the screen and doesn't get written to the Accounts table (not the description though).
So I have obviously gone about this the wrong way and rebuilt the Accounts trying to use lookups. Here is my problem (finally you say). I cannot get the default value to lookup the fee table based on the fee code. Note I have not started on the VB side yet so please be easy on me. There is a drop down box for Fees Charged but this lists nothing, so like the query before nothing gets written to the Accounts table.
I think (maybe I don't) understand the lookup thing as I used an old (DOS) database before and did the same thing and was able to change the default value just for that account. i.e. lookup the table>field where the fee code is = to this. I have tried the subform wizard a few times but just cant get it right.
Should the lookup be in the table field or the subform. Am I on the right track and if so how do I get the retrieved info from the Fees table into the Accounts table. My end result should be something like this.
Fee Code(lookupFees - write to accounts), Description (lookupFees - display only), Fee Charged(lookupFees - write to accounts), Fees Paid(lookupfees - modify write to Accounts), Date(Accounts), Receipt Number(Accounts).
Thanks for taking the time to read this, I have tried to give as much information and hope I haven't given too much.
Hi, I am a newbie in MS Access. I am trying to write a simple database to record engineering drawings received. I would like to retain an entry into a field from a previous entry, but if it is slightly different allow the value to be overwritten.
For example:
If I receive a drawing from a particular person, (say) Osborne, then that is entered into the senders field. The next drawing I receive also from Osborne, wil already have Osborne in the entry field from the previous entry so I will not have to retype it. If a drawing is then received from someone else then Osborne is overtyped with the name of the new sender.
I have converted access DB to MS SQL database, while the code is still in Access.
There are several form, when invoked have default values (kind of template) these work fine in Access but not in converted application these default values show up after the record is saved.