Search results for query: *

Can you "customize" the new access ribbon using a .adp file? I have an existing 2000 .apd file we are using and want to update it with the 2007 version. It contains custom commandbars and shortcut menus. Is this possible? Thanks much

how can i call the Data Link Properties Window from Code to select different SQL server databases?? Please help

Help can I see who is logged into my database. I want to return the computer name of each person logged into the database. Thanks

A few personal touches and it works great!! THANKS!

Can this be done and if so, how??????

This line of code is throwing me for a loop.... frm.OnClick( Tag ) 'Add the function OnClick into your form What does this mean?????? Thanks

I have created a custom menubar for an application that I will be using in the near future. I need to pass the Tag Property of the commandbar button to a form I created to print various reports. How can I accomplish this?????

How can print report automatically on the last date of the month???

If have created the following code the populate a treeview control: Private Sub Form_Load() Dim db As Database Dim rst As Recordset Dim rstchild As Recordset Dim objnode As Object Dim strKey As String Dim strparent As String Set db = CurrentDb Set rst = db.OpenRecordset("tblDept")...

how can i use ampersand in the caption without it creating a hotkey

Tried it and it didn't work... Confused, because it makes sense. Any more suggestions????

I have the following funtion: Function Color() On Error Resume Next Dim ctl As Control Set ctl = Me.ActiveControl If ctl.BackColor = 16777215 Then ctl.BackColor = 14211021 Else ctl.BackColor = 16777215 End If End Function The event is fired on the GotFocus and...

I am using an .adp... I have a two forms #1 RFQ with a subform to add RFQ details #2 Purchase Order with a subform to add PO Details I have a command button on the RFQ form to create a PO from the RFQ. I got the RFQ information to the PO, but I am have trouble with adding the RFQ details to...

If have a procedure that searches for duplicate records... Private Sub_BeforeUpdate(Cancel as Integer) Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("PurchaseOrders", dbOpenTable) rst.index = "PrimaryKey" rst.Seek "=", Me!PurchaseOrderNumber If Not...

Now I get: Invalid column naem 'WorkOrders'.

This is syntax: Alter Trigger Customers_UTrigger On dbo.Customers FOR UPDATE AS IF UPDATE(Company) BEGIN UPDATE(WorkOrders) SET WorkOrders.Company=inserted.Company FROM WorkOrders, deleted, inserted WHERE deleted.WorkOrders=WorkOrders.Company END I keep geeting this error...

I am very new to SQL Server and I need to create a trigger that update the (Company nvarchar) record in the WorkOrders table when the (Company nvarchar) record in the Clients table is change Please help

I am very new to SQL Server and I need to create a trigger that update the (Company nvarchar) record in the WorkOrders table when the (Company nvarchar) record in the Clients table is change Please help

I'm having trouble deciding whick file type to use .mdb or .adp. (.mdb is easier to work with but .adp gets better performance and processing speed.) Anyone have any suggestions? God Bless America!

How can I incrementing dates values using "-" or "+"?