Search results

I don't want the access window to show, just the application hence I ran it minimized!!!

How do I turn the print option for users to click on? HELP

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?

The user has office 2013 installed. No worries...I just copied a shortcut of the accdb file to the users desktop. Works fine. Thank you for the help.

I installed Microsoft runtime for access2013...I developed the app in access 2013. They should have been in line with each other. How do you perform late binding? Would that just be going into the reference section of the app and binding?

The error came up when I deployed the access app to another machine using SSE Setup -> exe file install, etc. I also got a missing: Microsoft office 15.0 object library This might be causing the chr(0) error. I have split the database into front end and back end. I wound up creating a...

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?

Thank you...appreciate everyone's input especially Pat and Jdrew.

Here is my issue: I have a table with the following fields: Project ID Comment User Name Date For each Project ID I would like to get the LAST Comment, User Name and Date. The LAST meaning the newest comment entered. Hope this makes sense. I am having a hard time formulating the SQL statement.

Thank you jdraw...that link is very helpful

I believe I figured it out...using Last()

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

Thank you colin, I tried that and it doesn't work. I am trying to open a content server link. The code above opens 2 tabs - 1 to content server and 1 to the link. If I use the CreateObject("Shell.Application").Open "http://abc.def" just the link opens and it work. However doing this with...

Hi Colin, I tried: Application.FollowHyperlink txthlink.value It doesn't work.

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 solved it: =Sum(IIf([Project Status]="Completed" Or [Project Status]="In Progress",[Funds Commited],0))

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))...

Not sure if it helped...haven’t tested it yet. Thank you for the assistance. It is appreciated.

I can run the sql code in the query and I get no error messages

I tried to do: DoCmd.OpenQuery insertSQL where insert SQL is: "INSERT INTO Notes ([Project ID], Status, Comment, [User Name]) VALUES (5, 'In Progress', 'This is a test', 'dr'); " Still get the same error?