Search results

Here it is SELECT b.DT_DATE_BOOKED, b.DT_DATE_COMPLETED,b.TXT_REFUSED_REASON, b.IMG_PHOTO_ONE AS img_image,b.INT_CUSTOMER_NUMBER as customer, c.SalespersonName as [salesman name],c.CustomerName as customername, c.AddressOne,b.int_rejected as int_reject,c.City, a.TXT_BRAND_KEY FROM...

I have a form thats bases on a recordset. A query string is passes to the form as openarg and the recordset is generated. The query can be run two ways but the resulting fields all have the same names. The form loads no problem when the query is run one way, but the other way it crashes the...

Bump Looking for a Bump

Linked tables, just to lazy to change the names

I run this to look for images on the hard drive. If its there it updates the record to reflect that. Function UpdateAvailaiblity() Dim sMyFile As String Dim vCheckimage As Variant Dim sSql As String Dim rs As DAO.Recordset sSql = "SELECT dbo_TBL_HANDHELD_DATA.INT_PHOTO_ONE_AVAILABLE...

I have a table that has almost duplicate data. Ex. Table name = Table Key Name Time Location Mood 1 Bob 4/1/2007 12:30 Home Happy 2 Mike 4/1/2007 12:31 Store Sad 3 Bob 4/1/2007 12:32 Home Happy 4 Bob 4/1/2007 12:33 Home Sad I would like to be able to eliminate all but one...

I need to open an Access form from Outlook. How can I do this. I create an instance of access but when I go to open the form the code stops. Should I set it up as a new instance? Also how do I close it when I done Thanks Skater

Thank You all I figured it out. I was opening the form as a dialog. I did not know that it was modal. Once i figured out that was the problem and change the for to normal it worked like a charm Andy

Thank you, one more thing I have the form and it will open but how to keep the form open but keep the vba running behind it. As soon as the window opens the code stops Thanks

I have a vba function running and would like to have a form show and tell what part of the module is running. It would then update when the next part of the module is run. Ex. Start Form: Starting looking for stuff Form:Looking for stuff Found stuff Form:found stuff And so on. Please help...

Still null The openargs is still null. In the openform it shows correctly. When the new form opens it turns to null

Why do I get and error with this code? It says the openargs is null when I run it Private Sub TXT_SALESMAN_NUMBER_DblClick(Cancel As Integer) Dim StCustNumber As String StCustNumber = Me.TXT_SALESMAN_NUMBER.Text DoCmd.OpenForm "Frm_Slm_Name", acNormal, , , , , StCustNumber End Sub Private...

I am using the Internet Data Transfer Library to transfer images from web sites. The problem is the module does not release the images once they are written to the hard drive. It is set up to parse a string and find the link. It does that. It just won't let the images go Sub Trim_Text() On...

I have a table that is set to record a field survey. My employees are then sent out to remedy any problems found. What is the best way to enter this information. I would like to be able to view any work that was done by the emplyee. Would the easiest way to do it be duplicating the row and...

I hope there is a way to do this. I would like to have a subform populated by a combobox in the main form. Table Vendor Vendor Name VendorID Table Items VendorID BrandID BrandName I would like to select the vendor in the main form and have the subform populate with all brands associated with...

Looking for a way to skip a record in a report based on a query. I am running a photo database with the images linked to an imagebox. If the photo link is not valid I have a "sorry no photo" JPRG to show. Is there a way to skip the records with bad links so the Sorry JPEG won't show up. To...

Hi- I am using the following code to place images into reports and formsFunction setImagePath() On Error Resume Next strImagePath = Me.txtimagename Me.Imageframe.Picture = strImagePath End Function Is there a way to to not have a record show if the imagepath do not refrence an...