Please help,
Each construction project has an unique set of initial and monitoring questions to be answered.
The construction project can have many locations and may have multiple monitoring questions in 6 months intervals.
Also, some of initial and monitoring questions are the same. Some...
Hi,
I have these totals in the report:
=Sum([custcnt])
=Sum(Val([wgt]))
=Format$(Sum([glamt]),"$#,##0.00")
only sum([custcnt] is appearing on the Excel export. I am using Access 97
and using DoCmd.OutputTo acOutputReport, r2xls, acFormatXLS to export.
Does anyone know why the other totals...
Thank you, Thank you, for your responses.
I am going to need some guidance on looping through the fields collection to build the sql statement.
Please assist.
Thanks
Query?
How can I use a query when I don't know what the 3 dates fields will be.
Everything is done programmatically. The user clicks a button and the table results are exported to Excel.
Please assist.
Thanks
Hi,
Please assist.
I have a thick border around range and range a5:l8
I want thin borders around cells in range from a5 to the end of range.
The below code gives me the thick borders I want not the cells within the range.
Set rngAL8 = Range(Cells(Rows.Count, "A").End(xlUp), Range("l5"))...
Why isn't this code working?
I want bottom and right borders from a7:l7 to the last
row.
Dim rng As Range
Set rng = Range(Cells(Rows.Count, "A").End(xlUp), Range("L7"))
With rng
.Borders.LineStyle = xlNone
.Borders(xlInsideHorizontal).LineStyle = xlContinuous...
Please Assist
I would like a bottom border For each row on the sheet from columns a:l
For some reason this code does not work.
What am I missing?
Dim x As Integer
Dim lastrow As Long
lastrow = Range("A65536").End(xlUp).Row
For x = 7 To lastrow
ActiveCell.Columns("A:L").Select...
Hi,
I have 6 comboboxes. The user wants to be able to sort/filter in any combination with these comboboxes.
I have decided to change the rowsource(query) after each combobox update.
All of my data is displayed is a listbox.
My first problem is I can't seem to get the listbox columnwidth to...
Hi,
Please assist.
amtField is defined in the table as follows
datatype = number
fieldsize = double
format = percent
In the form I want to change the formating of this field for certain records
I have tried the following iif statements in the text box control source:
=iif([name] = "Jane"...
Hi,
I have a query using these fields:
date
planid
employeeid
amount
using the max function on date.
Somehow, it doesn't display the correct data and has wrong number of records.
For example it will display the amount for 12/31/2003 with the wrong date, 12/31/2004. When I remove the amount...
Hi,
I have unbound combo box that uses the findfirst method in the afterupdate event to display records on main form.
After adding a new item to the combo box using the notinlist event, the afterdate event findfirst method does not display the new record until I close and reopen the form. The...
Hi,
DoCmd.RunCommand acCmdDeleteRecord works fine except when the current record is the last record. I get a "no current record" error message.
I have tried rst.movefirst and rst.moveprevious after the command but I still get the error message.
Please tell me what I am doing wrong?
Thanks
Gwen
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.