how to get the "Debts Continue from" value in a Access Query
I only need to get the answer the name of the month or count of Months Debts finally continue from.
Supplier No
Name
April
May
June
July
Debts Continue from
1
Alan
-50
0
0
-1000
July or 1
2
John
-100
-105
-115
-120
April or 4
3
Perera
-15
0
-20
-25
June or 2
I am using Access 2007 & trying to update a database to include a check & balance.
Currently a user enters their name into a form, selects a check box (Pass or Fail) & clicks a save button. Real simple form. The actual testing is performed on a standalone piece of equipment separate or outside of the MS Access database.
Here is the challenge, if someone does select Fail, I want to ensure this person comes back into a blank form (new entry) & confirms they have eventually passed. I want to give a time limit of 10 minutes before an email is sent out to their superiors. (I have the email portion figured out already).
Other entries will take place before the failed user comes back to the entry form so the form needs to be available for other people to enter their results.
I believe this can be done using some VBA and a query but I am not sure where to start especially with the 10 minute allowance to recheck the test status.
I have an button on my form that exports the database to the A Drive. The[problem is that if the user hasn't put a disk in then an error is produced. I would like to create a message box saying 'Ensure that you have placed a disk in the A:/ Drive' then with a continue ox under it. I assume it needs some error handling with it as well, but I dont know how to do it. Anyone know?
View 2 Replies View RelatedI adapted the findform from the address book sample database. After the search is performed I would like it to be able to continue to browse (continue scrolling through) the rest of contacts rather than excluding everything but matches. More like a go to kind of search rather than a select query. I'm betting this is a simple fix (I hope), I just don't know what it would be. Any help?
View 1 Replies View Relatedthis is a progress bar, what i need is, while execute loop (progress bar) but also execute next command = "LedgerExe:
On Error GoTo Proc_Err
Dim inti As Integer
Dim dblPct As Double
[Code]....
I have made a contact form where particular member credentials are coming in text boxes, i have kept a combo box also on the top to view by the phone number, if the phone number is entered the credential of the member comes, and also the navigation buttons that is first, previous, next and last.
The main problem if i select phone number by combo box on the top, the navigation button do not continue from that part, even if i press next or previous it shows no records found.
I am trying to check for certain user levels then if criteria is met it will ask to continue then clear a table..
Code:
Private Sub Command9_Click()
If strSecLvl = dev Or admin Or sprvsr Then
If MsgBox("Do you wish to clear the logs?", vbYesNo, "Clear Logs") = vbYes Then
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from tblLogs"
[Code] ....
I have manipulated the duplicate record code found online to suit my purposes. It works for all the other subforms, however this subform has too many fields so the code goes onto the next line. How do I solve this? Online it says using "& _ " but I can't get it to work. There's basically too many fields to fit on one line so I need to continue the code onto the next line
Code with end of line problems highlighted in red:
If Me.[subformEmissionsControlTarget].Form.RecordsetClone.RecordCount > 0 Then
strSql = "INSERT INTO tblEmissionsControlTarget ( System_ID_No, EmissionsStandard, OtherEmissionsStandard, IntakeThrottle, OBDrequired, OBDVersion, DPFregenmethod, ExhaustTemperature, EGRTemperatures, EGRRates, SteadyStateCycle, SteadyStateEngineeringLimitType, SteadyStateLegislativeLimitSmoke,
[Code] ....
I have a button on my form, that runs a series of queries then closes the form. It works great!!
How can I get the MsgBox feature to continue with all commands or cancel and close the form?
Here is my code without message box action
Private Sub AcceptChanges_Click()
DoCmd.SetWarnings False
Forms!SelectCustomerNewCustomerF!MergedRecordsF!CustomerID = Me.SecondID
Forms!SelectCustomerNewCustomerF!MergedRecordsF!MergedTo = Me.IDprimary
Forms!SelectPrimaryNewCustomerF!MergedRecordsF!UserID = Me.UserIdChange
DoEvents
[Code] ....
All of these actions work great, and do not need to be modified. it is just a msg box button to continue or cancel and close the form.
Counting number of appearing records show in query
Name Drinks Date purchased Count
John Milk 8/3/13 1
->Mike Beer 8/4/13 2
John Beer 8/4/13 1
Peter Wine 8/6/13 1
-> Mike Beer 8/6/13 2
Counting conditions: counting will continue if NAME and DRINKS are the same
I sent a post earlier today about making a label visible in a subform! I am still working on it but still no progress!
I have a different scenario (its the same thing but trying to explain the method i'm working on):
I have one main form (frmMain) that contains 3 subforms, say subfrm1, subfrm2 and subfrm3. On Open only 1 is visible and 2 and 3 are invisible (however they are open and loaded).
By choosing an option on 1 subfrm2 becomes available! When choosing an option on subfrm1 a boolean called 'XXX' is set to true. Now i want one particular label to become visible in subfrm2 if 'XXX' is true! To do this i need to write a code to be executed when subfrm2 is appears on screen! The problem is this form is already open so how and on which event of subfrm2 can i write the code???
At the moment i'm trying to refresh subfrm2 (by using code in subfrm1) and I have placed my code on the On Load event of subfrm2. I thought this way the form will reload and the On Loand event will pick up the new value for boolean XXX and set the label to visible! Thats the idea anyway... here is the code i have in subfrm1:
XXX = True
Forms![frmMain].subfrm2.Form.Refresh
subfrm1.Visible = False
subfrm2.Visible = True
I'm not sure if refreshing the subform will result in On Load event to be executed! And i'm not even sure that the code for refreshing subfrm2 is correct. Can any1 help me with this?
I have attached the actual database on my previous post sent today, if you prefer to look at the whole thing and get a feel of the problem!
to automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.
So right now my form looks like below
CAD#
Person name
Charge
Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"
Officer name date page # of #
Thanks in advance.
Matt
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies View RelatedHello All,
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later
FROM TESTSTAT
WHERE [LOG_NO] LIKE '*'
ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
Thank You
Mike
Hello All,
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later
FROM TESTSTAT
WHERE [LOG_NO] LIKE '*'
ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
Thank You
Mike
Can anyone help? I have a query that queries against 11 linked views against an SQL Server backend.
The query is running dog slow, so I want to convert it to a pass-through query so that the processing is done server side rather than Access having to drag thousands of records across the network, but don't know where to start.
The problem is that I need to convert the Access SQL to a version of SQL that SQL Server understands.
Is there a tool I can use that does this automatically (keeping my fingers crossed here)? If not then does anyone know where I can find out how to do this?
This is a Oracle query... its working in Oracle but didnt work in access...
select v.code_number,v.vehicle_number,v.company_code,r.fc _valid_to,
i.next_due_date
from (vehicledetails v left outer join rtodetails r
on v.code_number=r.code_number AND v.code_number='SMR5'
left outer join insurancedetails i
on v.code_number=i.code_number);
I need equalent Access query for this.... anyone plz help....
I have made this query in ms sql it works fine as per my needs iam getting the values but this doesn work in ms access 2002 can someone work this out its lil urgent tested out a lot of things but better to give the best people's n get their knowledge...
SELECT wc.windowsname FROM windowsconductivity as wc join constructiondetailes as cd on wc.windowsid=cd.materialid join uvalueconstruction as uc on uc.constructionid=cd.constructionid join projectmasterwindows as pmw on pmw.windowconstruction=uc.constructionname WHERE pmw.projectname='new8thmarch07' and pmw.windowconstruction='new8thmarch' and uc.constructiontype='windows' order by cd.constructiondetailsid
thanks aton...
Is it possible to run a query that's inside an Access database from another program? Possibly excel.
I continue to run into walls with the fact that I can't get my company to buy licenses for Access to put on PCs. I'm determined to work around these issues, but there are obvious limitations.
Right now I got Excel sheets linked to a database where it pulls information of a main database that I'll update. They hit a macro button and it fills their sheet with the information I've provided in the database. At the end of each shift, I pull the information back into the database with the updated numbers for the day with a Union Query, then collect all the data into a new table.
The "old" way was cutting and pasting data from 60 Excel sheets every day which took 2 1/2 hours. I accomplish it now in about 10 seconds. Enough patting on the back.
The problem is that I need to delegate some of this out because I simply don't work all three shifts that we have and I want someone to "pull" the data after each shift. Of course, the people that I want to do this do not have Access.
How can I enable them to run these queries? Is it even possible?
Am I missing another way to do things?
Thanks in advance...
Hi guys im trying to create a access database which has two colums like the example shown below.
Registry total registry
/// 3
basically the first colume would contain these symbols /// and i want the second colume to read off the first colume soo if I have /// the total registry colum would show the total number of ///.
how woud i get the tables within access to do this:confused:
Hi,I am new to database work.I have to write a query to design a report basaed on the data coming from raw table.I have a table which contains sales information like deal name,code,closing date of deal,total revenue for the year and probability.I have to write a query to get the new data based on the table containing raw data.
My query should contain monthly revenue and quarterly revenue based on the fields closing date and total revenue.ex:If the closing date for a particular deal is mar-08 then the total revenue entered in revenue field should get updated in a new field [march month].Please help me how to build a logic for the query.I have to design a report based on this information and source should be one table.
Any help would be appreciated...
pls help me thanks in advance...
below table givesidea to build a query:
Closing date Jan Feb Mar Apr May Jun Revenue Q1 Q2 Q3 Q4
Mar-08 1,500 1,500 1,500 0 0 0
Jun-08 4,000 4,000 0 4,000 0 0
Dec-08 6,000 6,000 0 4,500 0 6,000
.............................
..............................
Regards,
Sam
How can i find max date and close value corresponding to that date. The following query doesn't work as A.Close is not a part of aggregate function and using group by on A.Close gives undesired results.
SELECT MAX(A.Date), A.Close
FROM (tblSecurityDay A INNER JOIN tblSecurity B ON A.SecurityID = B.SecurityID)
INNER JOIN CompanyDetails C ON B.SecurityCode = C.CompanyCode AND B.CompanyKey = C.CompanyKey
WHERE C.CompanyCode = 'ABC' AND C.CompanyKey = 1
Thanks
Hi,
I have recently started working on a Access database and I have very little knowledge about it. This is what I am trying to do: I made a form with 4 text boxes on it. The user fill sout the info in these text boxes and then hit a button. What i want to happen is:
One of the fields is actually a criteria for a query. Depending on what the field entry is, I want to make a report will all the records that match the criteria. eg: if the user types in 278 for a lot # criteria (one of the boxes on the form) then, i want all records that match that lot # to appear in a report.
I really have been struggling with this. Please help. Thanks ~svn
Hi,
I have recently started working on a Access database and I have very little knowledge about it. This is what I am trying to do: I made a form with 4 text boxes on it. The user fill sout the info in these text boxes and then hit a button. What i want to happen is:
One of the fields is actually a criteria for a query. Depending on what the field entry is, I want to make a report will all the records that match the criteria. eg: if the user types in 278 for a lot # criteria (one of the boxes on the form) then, i want all records that match that lot # to appear in a report.
I really have been struggling with this. Please help. Thanks ~svn
Im importing a file into access and i want to add querys. The problem is the field im querying wont always be in the same place or be the same name. The only thing that remains the same is that the field i want to query will always be the last column. Anyone know what to do for this??
Thanks
Marley.
Hello
I want to pass a parameter to this query determining how many records to select
parameter to replace the (Top 10 )
Select Top 10 * from customers
order by id
any idea will be appreciated
Thanks