Search results

Using VBA in excel I want to place a string in an email: With newEmail .Body = "Approval Instruction are as follows:" End With I want 'Approval Instruction' to be highlighted and made bold. How do I do this?

My form has a text box which has a control source pointing to a different form. When I use me.dirty = false and it automatically writes to my table, the text box value does not get recorded because of the control source. How can I ensure that the text box value gets inserted into the table?

I working on a multiple form access application. On my machine, where I am developing the app all works fine. When I copy the shortcut to a client machine one of the forms that should be opening locks the application. When I go to task manager the form looks like its open. I use the following...

My forms have popup -> yes and modal -> yes. When I close my current form I get the save window pop up however it does it on the parent window and the current window is now behind the parent window. How can I ensure that the Parent window doesn't appear until the current window is closed?

I created an application, set the run option to minimized on the shortcut and after opening a report I have no way of allowing the user to print the report. How do I do this?

When I deploy my access application and I run it I get an error at this line: GetLogonName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1) It seems to have an issue with Chr(0). Can you help please?

in sql you can do a select with top(1) parameter. How do you implement this in Access?

Trying to open a hyperlink using: CreateObject("Shell.Application").Open "http://abc.def" My problem is that the hyperlink is stored in a text box. Therefore, when I try to do the following: CreateObject("Shell.Application").Open textbox.value it doesn't work. I tried to save the...

I am trying to sum a column when project status is either "Completed" or "Deffered". With the following it works fine: =Sum(IIf([Project Status]=("Completed"),[Funds Commited],0)) However when I do this, I get an error: =Sum(IIf([Project Status]=("Completed", "Deffered"),[Funds Commited],0))...

Trying to run and insert statement using: DoCmd.RunSQL insertSQL I did msgbox insertSQL: "INSERT INTO Notes ([Project ID], Status, Comment, [User Name]) VALUES (5, 'In Progress', 'This is a test', 'dr'); " Not sure why I am getting this error?

I am opening a report using: DoCmd.OpenReport "rptName", , , acDialog I am trying to get the report to open in popup mode and not to open to the maximum page size. Tried various combinations of arguments after the report name in DoCmd but nothing works.

After opening up a form I populate the combo box value using the following code: DoCmd.OpenForm "Notes" Forms!Notes!cmb_ProjectStatus.Value = Module1.ProjectStatus Everything works fine until I split the database to front and back end. Once I do that the combo box does not populate. Any idea why...

I created a shortcut to my access application. Under shortcut properties I selected Run: Minimized. When I click on the shortcut the access client opens in the background with my application in the foreground. I close the application and click on the shortcut again to restart and the...

I am using: DoCmd.GoToRecord , , acNext To scroll through my records. My problem is that when I click next on the last record it opens a new record which I don't want. I want to display a message saying "You have reached the last record". How do I determine if I have reached the last record?

Trying to open a form using: DoCmd.OpenForm "Notes" Nothing happens. Help!!

Is it possible to have a multi line list box in access?

I have 2 forms open. I close one of the two forms. Does any event get triggered in the form that stays open? I tried to set focus to the form that stays open hoping that the gotfocus event will get triggered but it doesn't. The form current event doesn't get triggered either. How do I trigger...

Having issues with DoCmd.OpenForm. I specify a search criteria, no errors pop up and when the form opens it goes to a new record. Also, the filter option at the bottom of the page turns yellow. When I click on it, it goes to the first record in the database, click again and it goes to the...

Good morning, New user from Toronto, Canada. Just wanted to say hello. Daniel