Hi everybody!
Is it possible to set the properties for an access database not to confirm the changes when running an update query. I have done it under tools/properties etc. but then I make it in access in general. I want it to apply on one singel access database.
Anyone?
eroness
Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties.
Some of my column titles are long, and I'd like to be able to word wrap them essentially. Anyone know if this is possible? Thanks.
I am experimenting with Access Project and recently set up the MSDE 2000 on my desktop. My question is how do I set up user level permission in it simular to the user level security in access. I read that the MSDE 2000 or SQL 2000 has betten security features than MS Access jet, yet I haven't found a way to look into the property of the MSDE. Do I need another application in order to view the operating property of the MSDE or its security feature?
View 4 Replies View RelatedHi Guys,
Does anyone know how i can get an excel file properties from Access. Thanks.
Hi Guys,
Does anyone know how i can get an excel file properties from Access. Thanks.
Hi,
I'm trying to migrate an Access 2000 project to Access 2007. I want that the frontend doesn't look like Access. This means: no ribbons, no office button, no Quick Access Toolbar, no database panel. In 2K, this was rather simple, but in 2007 I only managed so far to get rid of the ribbon (by replacing it with a blank ribbon) and the navigation pane, but I can't figure out what to do to hide the Office button and the QAT.
Can anyone help me with this ?
Hi,
I'm trying to migrate an Access 2000 project to Access 2007. I want that the frontend doesn't look like Access. This means: no ribbons, no office button, no Quick Access Toolbar, no database panel. In 2K, this was rather simple, but in 2007 I only managed so far to get rid of the ribbon (by replacing it with a blank ribbon) and the navigation pane, but I can't figure out what to do to hide the Office button and the QAT.
Can anyone help me with this ?
:confused: I need to find a way using macros to accomplish this task: I am trying to set the LimitToList property as a YES, and enter data that is not in the list already, but instead of the NotInList property giving me the following error "The item you entered is not in the list. Please choose one from the contents of the drop down box", I want to branch to a macro entered at theNotInList property to branch to that will eliminate the error, and give me the opportunity to enter my own message with options for the user to enter the item into the list, or try to choose an item from the drop down box instead. I want to do this with a macro if possible. I have seen many VB solutions that purport to solve the issue, but to be honest, I am not very well versed in VB procedures. That's why I would like to do it with a macro. I am very competent with macro procedures! Please help ASAP. Thanks.
View 1 Replies View RelatedI have a Form with embedded Subform, everything works well as far as moving through records. Scrolling through records on main table via Form brings up correct records of child table on Subform, so the link between the 2 tables is done properly.
I use this logic to lock/unlock a field in the subform.
Code:
Private Sub Form_Current()
If IsNull(Me.Parent!Spec2) Then
Me!Value2.BorderStyle = Transparent
Me!Value2.SpecialEffect = Flat
Me!Value2.BackStyle = Transparent
[Code] ...
I confirmed with debug that the logic does set the properties properly. They are updated once and that's that. Any further passes through the logic do not update on the form. They do pass through correctly, changes are just ignored.
It doesn't matter if I use the logic from the Form and refer down, or in the Subform and refer up, the Subform never gets updated. I tried Repaint, Refresh, Requery, nothing works. I cannot count the permutations I've tried.
Why the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
Hi,
I have created a sub form and wanted to make it's background transparent and also be able to enter new data and change it on the form. I sat Data entry = Yes, but I still can't enter any data. And I can't find the Back Style property at all.
Any help how to do that will be very much appreciated.
B
I was doing my assignment with the table in access, and my sister came up to me and ask me “why it is important to check the properties of each field in a table before developing a form based on that table.” Can anyone help me and answer this, because I don’t know how to answer her question.:confused: :confused::confused:
View 1 Replies View RelatedAm sure this is an easy question but I'm missing something:
How in the heck are you supposed to get to the subform properties box. The only way I know is to click on the very thin border area surrounding the form and then try and right click your way to properties. There has to be an easier way. Usually I have to fight my way to the properties box as the area loses focus by the time I right click and I have to reselect and try and right click again...ARGH!
hi all,
i m referencing a control like me!<controlname> in my code.
but in 1 screen its not giving me option after me!<ctrlname>.(only value property).
but in other screen i m able to access the properties.
So what could be the reason for this.I particularly want to access the enabled property to set it dynamically.
Thanks
How could I implement a feature which determines if something is at least 7 days before a booking at a theatre, but no more than 2 months. For example, something like... If =Now() - 7 Then... Elseif =Now() Then...
I don't really know how to go about it.
Hirer Date is when the booking is to be held (e.g., 12/01/2006) and Booking ID is when it was booked over the phone. (121205/M = 12/12/05 in the Morning) If someone could help me I'd appreciate it greatly. :D
ciao people
i've been looking around for days, hope u can solve my problem!
my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)
can u please help me?
ciao people
i've been looking around for days, hope u can solve my problem!
my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)
can u please help me?
Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name.
This window has several tabs including "Summary" and "Custom." It looks like this should be stuff that I can set and then reference from within my code.
My thought is that I can use the "Title" from the "Summary" screen as a variable for all of my msgbox titles. The other interesting one is "Project" on the "Custom" tab. It looks like this may be the same sort of thing.
I've found that the Access Help is absolutely useless - I'm about ready to take a shotgun to "Clippy." But as they say, a display is a terrible thing to waste <grin>. I've also found that it's getting harder and harder to find what I'm looking for in the MSDN library. There's so much stuff and they don't always file it in logical places.
Well, thanks for reading.. sorry for the rant. As usual, any help is appreciated!
Cheers!
Can anyone tell me a sample code on how to write/develope the Advance file properties like....
File version
Description
Internal Name
Product name
I have seen different types of files properties some has additional features while some has none - its just click once on any file and then click the right hand side mouse button and select the properties that will display all the information about the files click on second tab version (if there) will tell you the additional info about the file.
I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.
View 3 Replies View RelatedI have an Access database split into FE/BE. For the front end, each user has his own directory on the lan. The directory is named with the UserName.
I've created an installation program in Access. It basically installs the icon on the user's desktop using Environ("UserName"). It also installs an Excel file the program needs on the hard drive.
Here's the problem...Right now, the installation program grabs the shortcut off the lan and installs it, but that shortcut has one user's UserName hard coded as the target. That one piece of information needs to change for each person. Is there a way for the program to modify the target based on the username of the person running the installation program? Without this piece, I need to visit every user after he runs the installation program and modify the properties of the new icon to point to his specific directory.
Thanks for any help you can provide!!
I was hoping someone knows how to disable the ability for users to gain access to the properties window.
When viewing a form (or any object), one can usually right click, click on the corner of the form, or a few other actions and gain access to the properties option. If selected, the properties window is displayed with all the object's properties.
Is there a way to NOT allow the users to select this option? i.e. to disable this option from the menu list?
Thanks for any help you can provide.
-arm1
I have a list of files which contain the full path of the file (dir & filename), how can I get the extended properties for these files?
I try to use the script
Dim arrHeaders(35)
dim sFolder as string
sfolder = "C:Scripts"
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace(sfolder ) 'objFolder = nothing even after the object is set.
It does work; however, if I were to hard-code the path in the NameSpace("c:Scripts")
For i = 0 to 34
arrHeaders(i) = objFolder.GetDetailsOf(objFolder.Items, i)Next
For Each strFileName in objFolder.Items
For i = 0 to 34
msgbox objFolder.GetDetailsOf(strFileName, i)
Next
Next
Any thoughts on this?
Thanks.
I have been running 2003 on XP SP2 for some time but a couple of days ago I needed to do a 'detect and repair' on Word but without resoring defaults. When I opened Access, the Properties Window was back to its default (small) size and couldn't be resized. An uninstall/reinstall made no difference.
Has anybody got any idea what might have happened and what I can do to put it right? I usually have it the height of the screen and this is driving me nuts!
hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.
thanks for reading.
Seiky
hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.
thanks for reading.
Seiky