Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.
Thanks.
I have a problem. The problem is that I have a form contains two list boxes controls and a calender control. The calender control is invisible by default.
When I click a Show button, to show the calender contol, it appears but behind the list boxes controls. How can I allow it to fully appear on top of all the controls in the form.
Thanks,
I have never used the tag property but while reviewing some design stuff it occurred to me that maybe I am overlooking it's usefulness and was wondering how some of you may have used it...?
View 8 Replies View Relatedhello,
I have a txtBox. Its backColor property changes according to what I do on the form. Now, when I close the form and reopen it, the backColor is not the same one with which the form was closed.
Ex. red, green
if I close the form having the backColor = green, then when I reopen it, it changes to red.
Can anyone tell me what I am missing
Thank you
Hi all
I have searched through this forum and on google, and I know that I can refer to a combobox's column property IN VBA by
[myform]![mycombobox].column(1)
When I do this in SQL, it complains that there is an "unidentified function" (column). What am I doing wrong?
How do I set the Required property for field that already exists via SQL. I'm thinking along the lines of: ALTER TABLE table1 ALTER COLUMN field1 text(50) NOT REQUIRED.
But this doesn't work, any clues?
I'd like to create a table with 240 fields. I know that the max is 255, however, I'm getting a message "property value too large" after I've created 114. Any ideas? All the number fields are byte size. Thanks!
View 10 Replies View RelatedI build a form with Combo Boxes, and can not find "DropDownList property".
Can anybody help me.
Thanks
I guess I have too many columns in my database and I'm getting the error message "Property value is too large" when trying to open the database table. When I was using Access 2000, I was still able to open the database but using Access 2003, the database will not open. Is there a way around this so I can open the table to fix it?
View 14 Replies View RelatedWhat I'd like to do is for my combo boxes to say something like "Select One" when the form is first loaded, until the user opens the box and selects something. My combo boxes work fine now, but they are currently empty when the form loads.
From my google research it appeared that the OnLoad property would probably help me do what I want, but I can't seem to find this property anywhere in Access. It's not anywhere in the property window and the help search doesn't return any results.
I'm using Access 2003 from MS Office Professional Edition 2003.
Am I missing an upgrade or does my version not have this property, or am I just missing it?
Hi all
I have a lstbox on a bound form. the lstbox is based on a query. I want the first item in the box to be selected. This is what ive used:
Private Sub roll_class_select_AfterUpdate()
DoCmd.Requery "lststudents"
Me.lststudents.Selected(0) = True
End Sub
But then the form gets stuck. None of the other controls will work. The first list item is selected but it then wants to be the centre of attention and everything else can bugger off.
Any ideas as to how I can fix it??
Damon
When I attempt to run my results page with paging I get the following error:
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/slug/revslug/Administrators/AdminReports/Timesheet/TechnicianAllocation.asp, line 185
I have included a few key lines of code:
Code:strDBPath = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.Mappath("/slug/RevSLUG/DB/TimesheetDB.mdb") & ";"if strTechName = "All" Then strSQL = "Select " & cstr(strReportType) & ", SUM(Hours) as SumOfHours FROM Results WHERE (PerDate >= #" & cdate(strStartDate) & "# and PerDate <= #" & cdate(strEndDate) & "#) GROUP BY " & cstr(strReportType) &";"ElsestrSQL = "Select " & cstr(strReportType) & ", SUM(Hours) as SumOfHours FROM Results WHERE (PerDate >= #" & cdate(strStartDate) & "# and PerDate <= #" & cdate(strEndDate) & "# and TechName = '" & cstr(strtechname) & "') GROUP BY " & cstr(strReportType) &";"End IfSet rstSearch = Server.CreateObject("ADODB.Recordset")rstSearch.PageSize = PAGE_SIZErstSearch.CacheSize = PAGE_SIZE' Open our recordsetrstSearch.Open strSQL,strdbpathiRecordCount = rstSearch.RecordCountiPageCount = rstSearch.PageCount' Move to the page we need to show.rstSearch.AbsolutePage = iPageCurrent'this is line that contains the error(line 185)
How can I fix this problem...I think it has to do with the settings when I open the DB but I don't know what the settings should be to make it work correctly.
Thanks
Mark
I have a subform (subform1) which allows me to select a value which then dictates which record is shown in the other subform (subform2). I want to run a macro every time subform2 has a different value -- without me having to click anywhere in subform2. I have tried to attach the macro to every place I can think of and it just doesn't seem to run. I am thinking it is because subform2 isn't receiving the focus. How do I give subform2 the focus and which event property should I be trying for?
View 1 Replies View RelatedIs there a way to change the background color of an field that has enable = off from the default "gray"? I can set it to transparent but I can't change the font color to see the data clearly.
Just trying to make the form "nice looking" to the user.
Thanks
Jeff
I have seen someone's database that had tiny circles containing a "?" which, when clicked, opened up a sentence or two. A search for "Tag" on this site strikes out, also.I am hoping to place these little links near fields that may need more explanation. In the ones I have seen before, the little explanation field that popped up disappeared as soon as the focus went elsewhere without the user having to close it. I have succeeded in using the tag property to open a true popup form, but this is clunkier than I want--would just like to learn how to do the other.
View 4 Replies View RelatedI have designed a software package based around an Access Database at my company (based in the UK). There is a good chance that the company will be able to sell the software and potentially make a handsome profit.
My boss wants me to sign an Intellectual Property Rights agreement. Does anybody know what this means? Which of my rights does it effect? Would it prevent me from developing the same software if I left the company?
Any help would be much appreciated. I've found some resources on the web but they seem to apply mainly to music. Just wondered if anyone had had a similar experience.
Cheers.
Hi All,
I am experiencing the following error when trying to execute this snippet of code:-
Run-Time Error 1004: Unable to set the LineStyle property of the Border class
appXL.Selection.Borders(xlEdgeTop).LineStyle = xlContinuous
appXL.Selection.Borders(xlEdgeLeft).LineStyle = xlContinuous
appXL.Selection.Borders(xlDiagonalDown).LineStyle = xlNone
appXL.Selection.Borders(xlDiagonalUp).LineStyle = xlNone
appXL.Selection.Borders(xlEdgeBottom).LineStyle = xlNone
appXL.Selection.Borders(xlEdgeRight).LineStyle = xlNone
appXL.Selection.Borders(xlInsideVertical).LineStyl e = xlNone
appXL.Selection.Borders(xlInsideHorizontal).LineSt yle = xlNone
It errors at the highlighted line above (xlEdgeTop).
I have tried numerouse things, but cannot figure it out. Have used this with With statements, moved the offending statement up and down the code, but to no avail.
The Excel cell I am trying to format is in the centre of the spreadsheet. ALl the other borders are fine, but this one doesn't want to know!
Thanks in advance,
Paul.
Does any one know of a way to toggle a multiselect listbox's property programmatically?
The One In The VBS Help doesn't work!
Hi all..
I use the following code in my application to select a particular column value in a list box..
myvalue = SearchResults_LB.Column(5, i)
In my computer the column count starts with 0. So, the above statement sets the myvalue to the 6th column. But when I install the same application on an other computer it sets myvalue to 5th column.
Looks like I need to set the base value of the listbox column property somewhere!
I hope it is an easy one for many of you.
Thanks in advance.
hi guys,
easy question.
when the DB is open a login form comes up. The issue is that the properties window for that form comes too.
any suggestion? thx max.
Hi,
I am using a macro to export a table to an excel spreadsheet. It seems like I have to write the absolute path in the macro's file name property, otherwise it doesn't work. The problem with that is that I have to change the path name whenever I move the folder to another location.
Any help will be very much appreciated.
B
I have a table named: tblStudents
I have a fields named Course and Basic Code Enforcement
Within the properties for Basic Code Enforcement, I have this as a Lookup row source:
SELECT IIf([Course]="Residential Inspector Multi-Discipline",1,"") AS Expr1 FROM tblStudents;
It is also set as Listbox, Table/Query
The main goal is to have the field RBasic Code Enforcemente show a 1 if the Course field is Residential Inspector Multi-Discipline. I have been at this all morning and I can not figure this out.
Thanks in advance for any help.
Dan
I have a form with a subform on it, if the user clicks a control on the subform I want to set the subforms visible property to = False.
I have tried Me!Subform.visible=False and Form!Subform.Visible=False but neither are working, I think i have to set focus back to the main form before I can set the visible property of the subform.
Is it possible to use a subquery as a default value property setting?
I need to use a value from a table that is not the focus table of the form, I have tried to identify it with a subquery but it returns a #name? error every time. I hate those!
Any help would be appreciated.
Hello,
I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property.
I have no idea what this does though, even though it seems intuitive? it's a form... so what is there to order? hope i'm not just being very stupid!
Thanks
Peter.
Having difficulty with executing the Recordsetclone property of my form.
Recordsource for 'frm_event' is based on a table, tbl_events.
On the Form's 'OnCurrent' event, I make a call to the function 'DisableEnable([Form])':
Public Function DisableEnable(frm As Form)
Dim rstClone As Recordset
Set rstClone = frm.RecordsetClone
Getting a 'Type mismatch' error when I try to create the RecordsetClone.
This is my first attempt at working with the RecordsetClone property.
Any help or guidance would be appreciated!
John