Search results

i am trying to subtract Personal time (number) from the Total Time (time duration formatted hh:mm) to get Net Time. I cannot seem to figure out the correct syntax. Not really sure why I am getting 15:00 either. Looking for line 1 to be 9:00 - 3 = 6.00. It is possible there could be a fraction...

I have a query with a bunch of columns. In data sheet view it looks good. When I export the query to excel I get 6 extra columns that are not part of the query but are part of the table. Why am I getting the extra columns on the export?

I have a form I would like to close without saving the record using a button. here is the code I have but it closes the form and it also writes the record to the table. Private Sub ClosewoSave_Click() Cancel = True Me.Undo DoCmd.close DoCmd.OpenForm "frmMenu" End Sub I found in a thread that...

I have 2 controls on a form cmbFed and cmbState both are formatted as fixed with decimal places as 2. They display the correct values. cmbFed = .18 cmbState = .06 When I add a new control to add the 2. =[cmbFed]+[cmbState] result is .18.06 instead of .24 It looks like it is treating them...

I am trying to load a form based on an if statement. I think my issue is that I have the DB set to Display form "frmSplash" on open. I have tried the following (frmSplash form load event) but it continues past the frmMenu and stops at the frmSplash. I want to open the DB and look to see if it is...

I am trying to open a form using the where clause to max of a table field. I cannot get the syntax correct. DoCmd.OpenForm "frmInput", , , Max(tblClients.ClientID) AS MaxOfClientID FROM tblClients

I have a table that has a field for month represented by a number. I would like to report by month but group by year. The report would group months 1-12 into year 1, months 13-24 into year 2, months 25-36 into year3, etc..... up to possible 20 years. Is there an easy way to identify and group...

I have a table tblExtInc that has multiple records with fields StartYear EndYear Amount Inflation Freq Source 2 8 1000.00 .02 12 SS 6 10 2000.00 .00 12 Pension Here is the code I have to Update a table tblExternalIncomeSchedule It works fine and...

I am the first to admit I struggle with looping through records.:banghead: I am trying to loop through a table and collect external income data and write it to a new table. My issue may be the way the table is laid out. ??? The attached pictures show the tables. The tblExtInc is where the data...

I have a tabbed control form that I an using as a survey form. It has Next and Back buttons to navigate the survey. Is it possible to disable the navigation feature of the tabs and allow the user to ONLY use the Next and Back buttons? Right now I have a label plastered over the tabs - It works...

Is it possible to move a rectangle control using code? I am trying to create a visual representation of a number on a linear scale. I have a control named RiskIndex which will have a value of 0 - 100. I would to "Slide" a rectangle named Box1 along a line from 0 = Far left to 100 = Far Right...

I get the OpenReport action canceled when trying to open a report using Private Sub Command21_Click() DoCmd.OpenReport "rptNet Worth", acViewPreview End Sub The report opens fine directly from the database.:banghead:

I have this code Private Sub Command12_Click() Dim x As Integer Dim y As Integer x = Me.spouseage y = Me.clientage Me.rdt = DLookup("[40]", "TblJoint", "[OldestAge]=70") End Sub It works fine. However I need to replace "[40]" with x and replace 70 with y. I can't get the syntax right. I have...

I am filling a table with calculated data. There is a StartDate field (supplied as a variable) I need to fill the table with the next month first day. It is a payment due schedule. I will supply 1/1/2013 then I need to fill the table with 2/1/2013 3/1/2013 4/1/2013 ....etc until end of loop. I...

I have a table [tblReportList] that lists all the reports. Each report (record) also has a checkbox (Print). I have a form that lists the reports and shows the check box. What I would like to do is have the user select the reports they want to print by checking the print checkbox. Then hit a...

I have a table where I calculate monthly interest for x years. I would like the best way to sum the column Interest for each year (month 1-12, month 13-24, month 25-36 etc..) and update another table where interest is by the year? Sum column interest where month = 1-12 and update table...

I have searched and searched and have ALMOST concluded what I need is not possible in VB. I hope I am wrong and someone can help. Here is what I am trying to do. Solve for X where all the items in red are parameters. I put this equation in an online algebra solver and I get the correct answer...

I am trying to modify the Microsoft Contact Management Database template. On the Contact list form there is a hyperlink to Show/Hide Columns. The event is an embedded macro RunMenuCommand Command UnhideColumns. I cannot figure out how the popup form is linked to the table or how to modify the...

I am very new to charts/graphs in Access. I was able to create the chart data using a query and was able to create the chart in a report (it is correct). However the charts repeats itself 12 times. I am sure it is because the query returns 12 lines of data. It is a chart of Sales by month (12)...

I have a main form with textboxes and a "search" button to filter the data and display the results in a subform. I am using code to set the record source from the values in the main form. Right now it is just using "AND". Example Vendor like "*ABC*" AND Date between datestart and dateend. This...