Recent content by chrisdedobb

Figured it out I figured out how to reset the sotred sql to blank. Just incase someone else is trying to do this, here is what I did: Private Sub Export_Click() On Error GoTo Err_export_Click Dim strSQL As String strSQL = Me.SQL_CODE ModifyQuery "U:\ErrorTracker\DB\TEST\ErrorTracker.mdb"...

Try this Here is a sample of your code and how to implement what you are trying to do: if isnull(Forms![frmletterMenu]![GPName]) = true then objWord.ActiveDocument.Bookmarks("To").Select objWord.Selection.Text = "" else objWord.ActiveDocument.Bookmarks("To").Select objWord.Selection.Text =...

I have a form that has an unbound field on it. This field is used to display the results of a SQL Query. I created a button to export the results to excel which is using the DoCmd.OutputTo function. I also have a Stored Query in Access that is blank (No tables or fields associated to it)...

Thanks for the advise but that is exactly what I am trying to do. What the purpose of this form is supposed to do is: 1: Person opens the form. 2: Pastes a screenshot into the field. 3: Clicks button and the db saves the contents of the OLE Object to a file on my hard-drive. This way I can...

Is this something that you want to check once each time you go to the next record? I am not really sure this is what you are talking about but this would run a command to hide the textbox if the label is blank and would recheck and hide/unhide textboxes each time you change to a different...

I am not sure what I am doing wrong. I have loaded up a sample DB that has a table with an OLE Object and a form that displays the Bitmap in an outbound OLE Object field. On that form, there is a button that does the following: Private Sub Command2_Click() Dim strPath As String Dim strID...

Thanks Sue! Sounds exactly like what I was looking for! I will give it a shot. :D

the pictures for the default templates can be found in: ....\Program Files\Microsoft Office\OFFICE11\BITMAPS\STYLES To attach them to the form, open the form in design view. Then open the Form properties. Under the format tab there is a field titled picture. click in there then click the...

One of my friends from work just emailed me this. Not sure where he got it, but it seems to be heading in the right direction. He says he changed the form and field names for me but I am still having troubles. Not the experienced with VB. ANy help would be greatly appreciated. Thanks in...

As I mentioned above, I have searched the forums. My situation was not addressed in the Sample Database Forums. Basically I want to customize the "Find" feature in access. The reason is my users will only be searching on one field and it will always be a partial value. I know how to write...

I am trying to create a form that the user can type a serial number in a text box then click a button which will close this "popup subform" and search the table and goto the record on the previous form that matches with the serial number. I have included a picture file to try and demonstrate...

I have tried both of these solutions but it is still not accomplishing what I need. Thanks for the ideas though! :) I am using a module that hides MS Access entirely so that might be why the first idea did not work. Is there a way that I can display the form imeadiatley and temporarily lock...

I have a few forms that take a while to open (not bad but long enough(10-15 secs)) I was wondering if there were a way to display a loading image while the user was waiting for the forms to load. maybe as an interm-form that has nothing in it but a picture? I am not sure if this is even...

Thanks Thanks for the help! I am not storing the calculated fields. Just displaying the calculated proposed dates next to a field that holds that actual date. I guess I did not understand the Me. part of the string. I figured out what it does now though. Thanks agian!

Here is my situation: I have a db that has a date field (short date format) that represents the date a job opens. In addition, I have 12 other fields that are proposed dates that represent a "goal" to make a selection. Every one of these fields could be autopopulated with a goal date if the...