convexcube
Joined: Dec 13 '07
Location:
-
Thanks ADezii, works a treat. Much Appreciated, Ken -
Disable application maximize button
Hi everyone,
Now that I've found a way to disable the ribbon etc. I need to disable the application maximize button. I have looked at this post and implemented it, but it disables the close and minimize buttons as well. Is there a simple command I can use to disable just this button or any way I can adapt the cited post to do just that?
Kind regards,
Ken. -
Thanks
Thanks ChipR, worked perfectly! Much appreciatedLeave a comment:
-
Disable ribbon, office button & quick access toolbar
Hi everyone,
I am trying to create a single window interface for my database. As I am using Access 2007, I have my document layout options set to tabbed documents without displaying documents tabs in order to get my main form to appear as the only element in the access application window. I have also set anchoring in the form so that controls that should always be visible are and others stretch to adjust to the size of the window. When... -
Thanks for that, I can see how a many to many relationship can benefit my situation and I will try that. I'll post on this thread again if I still have problems.
Thanks very much for your help.
Regards,
Ken....Leave a comment:
-
Thanks for your response mshmyob,
My Table structure is as follows
Persons
Person_ID (PK)
Person_NameFirs t
Person_NameLast
Users
User_ID (PK)
User_Password
User_Level
Person_ID (FK)
Customers
Customer_ID (PK)
Person_ID (FK)
Employees
Employee_ID (PK)
Employee_DOB
Person_ID (FK)
...Leave a comment:
-
Search using 1 textbox through multiple fields
Hi everyone,
I am developing a database which amongst other things records contacts and related information. This database is structured so that a person can be an 'Employee', 'User', 'Customer' etc or any combination of those. So I have a Persons table, a Users table, an Employees table and a Customers table all related by Person_ID. Persons can also have multiple tags (such as Electrician, Plumber etc), so this is in a separate... -
Hi Hooijdonk,
Would you be able to provide the source for your list box? and if different the structure of the underlying table?
Kind Regards,
Ken Farrawell....Leave a comment:
-
Well at least that will select the last item in the list box, which in my case was the last added item and the one I wanted to select....Leave a comment:
-
I've discovered the answer:
[CODE=vb]lstListBox.Sele cted(Form_Recor ds.lstListBox.L istCount - 1) = True[/CODE]
Kind Regards,
Ken Farrawell.Leave a comment:
-
Select an item in a list box through vba
Hi everyone,
I have done some searches and come up with no definitive answer. Is it possible to select a specific item in a list box with vba code in Access 2007
Thanks in advance for your help,
Ken. -
I would also like to know the answer to this question.
As a work around, I have found that searching google with the word "access" or "vba" along with a keyword very useful.
Kind Regards,
Ken Farrawell.Leave a comment:
-
That was actually the first thing I tried, but it didn't work either & neither did:
[CODE=vb]Set rpt.Printer = Application.Pri nters(Chr(34) & Me![cbxPrinters] & Chr(34))[/CODE]
Kind Regards,
Ken Farrawell...Leave a comment:
-
Hi Adezii,
I've got an update. I was able to avoid the error by using the Cstr function:
[CODE=vb]Set rpt.Printer = Application.Pri nters(CStr(Me![cbxPrinters]))
[/CODE]
Thanks for your efforts though.
Kind Regards,
Ken FarrawellLeave a comment:
-
Thanks for your response Adezii,
I have tried the code you suggested:
[CODE=vb]DoCmd.OpenRepor t "rptComplai nt", View:=acViewPre view, WindowMode:=acH idden
Set rpt = Reports("rptCom plaint")
Set rpt.Printer = Application.Pri nters(Me![cbxPrinters])
DoCmd.OpenRepor t "rptComplai nt", acViewNormal
DoCmd.Close acReport, "rptComplai nt"[/CODE]
Unfortunately the...Leave a comment:
-
convexcube started a topic Print report to specific printer from combobox containing installed printersin AccessPrint report to specific printer from combobox containing installed printers
Hello Everyone,
I have a form setup with a combo box that displays a list of the installed printers using code from this article. On a button called cmdPrint I have placed code in the OnClick event from the same article to print to a specific printer. The specific printer being the one chosen in the combo box. In the line:
[CODE=vb]Set rpt.Printer = Application.Pri nters("Acrobat PFDWriter")[/CODE]
I have replaced... -
Hi Goldstar,
I have a working example for you. PM me with your email address and I'll send it to you
Kind Regards,
Ken FarrawellLeave a comment:
-
No problems, I'm working on an example of how this would work. I will send it to you when done if thats OK. Let me know.
Kind Regards,
Ken Farrawell...Leave a comment:
-
Hi Goldstar,
I think I might need to see the whole database to get a handle on how you want to achieve this. Is it big? Would it be possible to send it to me? Let me know, and if you can I will PM you my email address.
Kind Regards,
Ken Farrawell....Leave a comment:
-
Hi Goldstar,
I think the reason you a getting the wrong field returned is that you are telling the text box "txtitemdescrip tion" to equal "stritemID" which was earlier defined as the value of the list box "hireDetail s". So although you have created a recordset and selected the record in the recordset that is selected in the list box, you have told the text box to display only what is selected in the list...Leave a comment:
No activity results to display
Leave a comment: