Search results

Hi, When I run this code, it works fine, but I get a value of "#Deleted" in the controls. What am I doing wrong? Thanks! If MsgBox("Are you sure you would like to delete History" & _ " from this record only", vbQuestion + vbYesNo,= vbYes Then Dim cmd As ADODB.Command Set cmd =...

Thank you for your help SpentGeezer!!

Thank you DCrake!!

DCrake - can you please tell me how to explicityly reference my form. I know the below is incorrect but it gives you an idea of what i am trying to do. Application.CurrentProject.Forms!Mafrm.Requery

Hi Everyone - I have a DB that I need to send out today. I have code that once runs - keeps giving me error "object invalid or no longer set" What does that mean please! The error appears when I try to requery a form that exists and is open. Please help!

Hi SpentGeezer - it does work if I use msoFileDialogFilePicker but then I am not able to allow the user to select where they would like to save their PDF File . . . I can't do anything with the FilePicker? I am certain their must be some solution to make this work?

Hi SpentGeezer, It is Error Number 438 - Object does not support this property or method. I am not sure what I am doing wrong??

Hi, That is acutally what I am trying to do - see below. The error is at - .filters.clear and .Filters.add - Any ideas? Dim fDialog As Office.FileDialog Dim varSelection As Variant Dim strFileName As String Set fDialog = Application.FileDialog(msoFileDialogSaveAs)...

Hi All, I have this code behind a cmd on a report. It works great. I would like to offer the user the option to choose a name for the pdf file and allow them to choose where to save the file. Can anyone perhaps provide some guidance on how I can begin to do this. I know I have to envoke the...

Thanks Hbrems - that seems to be working. I had to make a slight change here, .DefaultValue = Chr(34) & d & Chr(34) It didn't work without the Chr() - Thanks :)

Okay - thanks - I updated my previous thread. Forgive me for being dense, but, so that I can be clear, it is not possible to set the controlsource of a textbox to a date and save that?

So there is no way to just save it in the Textbox? I will have to create table just for that one value? If I set the controlsource of the txtbox to = "=date()" . . .why wouldn't that save??

Hi Everyone, I have a small issue. I have a pop up from with some command buttons and one textbox. One of the command buttons imports data from Excel into Access - that works fine. I wanted to place a date in the textbox everytime data is imported into the db. The text box is unbound...

MeU&US - can you please post your solution. This is something I would like to do but I don't understand how to allow myself access once I disable the shift key. Thank you.

Thanks Chipper - I tried one I found online but still no luck - no big deal - I can live without this - thanks for the tip!

Hi Bob - I didn't have any luck with it. The picture I had was jpg so I just renamed the file and changed the extension to bmp and placed it in the same folder as the database - I named it exactly as the DB name. When I open the DB it still show the MS Access screen. Is this because it the...

Thank Bob! Those were the directions I remember - I'll just try it and see how it works! Thank you Nigel - I am at work and am prevented from doanloading external apps :(

Hello - some time back I read on this forum that it is possible that when a person clicks on the Access Icon on the Desktop, when Access Launched, you can have a custom picture appear rather than the standard MS Access Spash Screen. I can't seem to find that thread now. Can anyone help...

Thank You Both very Much!!

Thanks Steve - it looks a bit complex but I'll see what I can learn from it. Thanks!