I used the code in the link below to get the login id returned on a form but I am having trouble now that I rolled out the database the code gives an error if the user has older than 2010 and even on a new machine that has access 2013 what is the best code to use? to return the log in id to a form?? without worrying about what version of access they have it wont be older than 2003. URL...
View RepliesI have two tables, [ATWelding] and [Results] . They are linked as they both have Weld ID.I want query to show any ATWeld ID that doesnt match a Weld ID in [Results].I can't use SQL as my database is on the web compatible platform. I attempted to do this using InStr([Results]![Weld ID]) in my Weld ID ATWelding criteria on a query but as I am using the web version an error message saying the expression is not compatible with the web is being displayed. I can run the query in my web database?
View 2 Replies View RelatedThis Access database is Web Compatible and is hosted on SharePoint. I have a form with a subform that display collections of records. As you can see in the attached image, the user selects a record from the combo box which filters the form/subform below. Each record will contain more than 1 item.
What I want to do is mimic a "Split Form". But, the last thing that is missing is being able to select an item from the subform (datasheet view) which displays several items in the record and have that item be displayed in the form. Currently, I have to use the record selector buttons at the bottom of the form to have the item I want displayed in full. But I want to be able to click the item in the subform and have it populate in the main form on this page.
I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round.
Now my question is, am I looking at this backwards? Would it be easier to import the excel file into access? Or should I stick to exporting data to excel? I want this to be automated as much as possible to the user has to do as little as possible (ideally, hit a button and the bracketing pops up...)
If anyone has any ideas (or possibly some VBA code....;) ) please let me know.
Thanks
Steve
Hi.
For years several agencies have used a database written and maintained in Access 97.
One adminstartor has both 97 and 200 on his computer and no problem. Until now, that is.
When I try copying a revised front end, and opening it, I get 'unrecogized database format' message.
My hunch i sthat said administartor accidentally opned the basck end with 2000 and converted it.
So, can the back end be unconveted/reverted back to 97?
Any other suggestions?
Russ
I have a continuous form based on a query.
The query is derived from three tables each in a 1 to
many relation to the next. (tables A, B, C)
So when I open this form (with filter A = 1) I expect to get this order:
A B C
---------
1 - 1 - 1
1 - 1 - 2
1 - 1 - 3
1 - 2 - 1
1 - 2 - 2
1 - 3 - 1
1 - 3 - 3
What I am getting is the records listed in the opposite order!
(1-3-3 on top, 1-1-1 on bottom)
Can anybody tell me why?
Thanks.
I really just want to get the recordcount of the recordset to display on my form.
Code:
Public Sub CallSP()
Dim cnn As ADODB.Connection
Dim rsSQL As ADODB.Recordset
Dim CmdSQL As ADODB.Command
Dim rsACCESS As ADODB.Recordset
[code]....
I would like to create a query that displays a date like this "20130315". Can this be done?
View 4 Replies View RelatedMaybe im looking up the wrong term...
I want to autoforward to the next blank...
Say I click a drop down box, after i select, i want to be able to automatically jump to the next field.
how do you do this?
Thanks in advance for any assistance you may render!
Mateo
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies View RelatedI have a form that currently adds services and products paid for by a client, via subform calculations, indicates payment, via cash, check or charge, and shows, finally, what is still owed. This is for a clinic and some old folks, for example, pay small amounts over time.
The subtotal, sales tax, total and amount still owed are all calculated controls that are functional, but only for the current record. Each transaction record has a date/time field. Each transaction record has the patient ID.
I need to carry forward that amount owed, so that the next time that person comes in, the amount owed control reflects any amount that was owed from the last visit. Is this a case where storing that amount in a field in the 'transactions' table would be justified? Or do I need to somehow incorporate ALL the code leading up to the amount still owed, SUMing it along the way? Very ugly...
Can someone, both, give me some clear suggestions on how to do this kind of running sum on calculated controls (since SUM only works on fields) AND point me to samples of calculated amounts carried forward, if necessary?
I need to use an update query to calculate the following 1st of April for each of 3000+ records, the only exception is if the Start Date is the 1st of April in which case the date will remain the same.
Examples
StartDateAdjStartDate
01/03/08 01/04/08
10/09/06 01/04/07
15/04/08 04/04/09
01/04/08 01/04/08
Can anyone advise the best way to do this?
Regards
Hawk
Hi,
ive created a balance shee for a football club as a continuous form with a balance being displayed in the footer along with total income and expenditure.
Because this is for a Football Club, I want to be able to do the balance sheets every season. To that end I have a included a date in the query.
Is there a way that I can carry a balance forward to the nesxt season, (next record). I want to display Last Seasons closing balance in the header of the new season and have the new balance include that?
I have three questions, both im sure are easy just overlooking something.
1) I have a search form where you type the search parameters into 3 fields, and then your click search. I want the fields to automatically clear after the search button is clicked (but enough time for the query to get the info from the fields).
2) A combo box is used to select the marketing type, when first clicked.. a dialog box comes up and gives the user instructions for the next blank. After the field is changed to the right selection, i need it to automaticcaly forward to the next box.
3) I need to use a text box to sure information. The table records only 1 line of text, does that mean you cant have 2-3 lines? Really just 1 line wrapped in the window?
Thanks in advance!!
Mateo
I'm wondering if there was a way to put a button on my first tab that, when pressed, will take me to the second tab.
Thank you.
Looking for an automation solution
currently I have a database for client progress and prescriptions. when the file is opened it is set for data entry so that a clean note form is opened. I have a button that pulls up past notes for their review.
it has been requested that there be a way to pull the last narative field forward to the new record for editing as a number of the features of the narative remain the same.
Currently the only way is for them to open the last seen note hightlight the field and past into the new note. to high level for some of them.
Need to make this an automated feature where they would just click on a button and the process would all occur behind the scean and the note would apper in the new note narative box.
I know that I could tell the form to not be for data entry but then they write over the last note. this needs to be a new record.
Any suggestions greatly appreciated
J
Table:
Date Item Quantity
------------------------------------------------
10/20/2013 Item-A 2
10/20/2013 Item-B 4
10/21/2013 Item-A 2
10/21/2013 Item-B -1
=====================================
On 10/22/2013, if Item was selected, I want to bring forward previous day balance as of 10/21/2013 for Item-A = 4 or Item-B = 3.
I have a table composed of the following fields:
1. Entry_ID:
2. Item:
3. Previous_Balance:
4. Increase_Or_Decrease:
5. Current_Balance:
Once the selected item had been entered, i want the Current_Balance of previous entry of that item to be forwarded automatically in Previous_Balance field. Is it possible? I have at least 100 types of items.
I have a table in MS Access naming "Salutation" and in the table I have 6 columns and each column named as Week No., Carry Forward records, new records, total records, processed records and pending records. Like below
Week No. Carry Forward records new records total processed pending
1 0 10 10 5 5
2 5 10 15 7 8
3 8 20 28 9 19
So now the requirement is every day pending records should get updated in the next row with in the same table under carry forward records of its next immediate day. For e.g. pending records of week number 1 which is 5 should get updated under carry forward records for week number 2 and so on.
I've got an access form, and all I want to do, is to be able to type a number into a text box, click a button and then for the record containing that number to be displayed (in that same form).
-And I dunno where to start.
I don't like using the navigation bar, although that is almost what I'm after.Also, search functions I've seen on here that use combo box lists to display results seem like too much for me, as each number typed into my search box will be unique.
I am a novice with Access and I would appreciate any help with two issues:
1. I am trying to get a value to forward to the next record in a different field so that I may keep a running total. For example:
Record 1. A field named Today is added to a field named Forward to get a total in a field named Total.
Record 2. I would like to get the value from record 1 in the Total field to carry forward to the the field named Forward in record 2.
The form looks something like this:
Today: 10:00
Forward: 2:00
Total: 12:00
I would like to get the value of 12:00 in record 1 carried forward to the Forward field of reocrd 2 so that the Forward field in record 2 would read 12:00.
2. I also need to add times together arithmatically but the problem I have is that when the total exceeds 24:00 hours it shows only the amount that exceeds 24 hours. For example, if I add 22:00 to 5:00 the result is 3:00 not 27:00. I need to show 27:00 as the total.
Any help with these two items would be GREATLY appreciated.
Thanks,
uspilot
I am having difficulty getting the right record to carry forward into a modal subform to edit/update information. The Request_nmbr is an autonumber field. The client can have multiple requests. When I open my subform, I can scroll through the records, but when I launch the "update" button, I don't know how to carry forward the request_nmbr so that I'm updating the right record.
Here's my code:
Private Sub Btn_Exception_SubModal_Click()
DoCmd.OpenForm "Frm_Exception_UpdateModal", acNormal, , acFormAdd
Forms! [Frm_Exception_UpdateModal]![Request_nmbr].value = Me![Request_nmbr].value
Forms! [Frm_Exception_UpdateModal]![clientnmbr].value = Me![clientnmbr].value
End Sub
I am developing a small database for use in a multi-user environment: I have split the tables off and am testing with two copies of the front-end on different machines. All seems to work well except on one form.
On this form, the value of a bound control (exposed as a number of radio buttons) is used to make related controls on the form visible or invisible. I use the AfterUpdate event to trigger appropriate VBA code to accomplish this; it works well.
However if two users have the same form open at the same record (unlikely, but not impossible), and User A changes the value of the control via the radio buttons, Access will eventually propagate the change to User B's copy of the form but the AfterUpdate event will not be triggered and the form becomes inconsistent. I understand that events are only triggered when a user makes a change to a control; how can I be alerted when Access makes a change?
I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
I'm working on a database at the moment with a fairly large dataset. I've used "between" functions and created date range boxes to filter query's to specific date ranges which has worked perfectly for queries. Is it possible to have something similar with forms?
The reason i needed to move away from query results onto forms is the ability to have an on click event to goto individual record which wasn't possible from the query results. I moved my query's across to forms which worked well except for the loss of selectable date ranges.
Is there a way of allowing user to reference/update from either databases ? If user enters an item code and it is not found in database A, can the program direct it to retrieve/update from/to database B ? Assuming database A and B are item databases with different contents.
View 1 Replies View Related