Search results for query: *

Yes for production floor. I thought about excel but I dont know how many lines I can display at a decent size font to be seen from a distance. It may have up to 30 - 40 lines. So far by putting a slide per customer (there shouldn't be more than 6 items per customer) then I can have multiple...

I have not found how to pull data from access into powerpoint. I am creating an instance of a powerpoint presentation it does not actually save anything into powerpoint. Just displays data in a presentation.. Then i used the interval to create a new instance every 15 minutes (or thats the...

I am currently trying to generate a powerpoint from access vba. And using the timer interval to basically close the powerpoint and start a new one with updated data. This shows about a 3 second glitch between closing show and opening new show. However, if I only refresh every 15 minutes I...

I have been working on this project. Search forums on here and also on the internet. And I was working on what I thought was the solution until I figured out I was displaying data that couldn't be updated. What do I want to do: My boss is wanting to display active orders on a screen in our...

I am having three or 4 picture put in different places on report. Is there away in vba? Chris

I cannot get a picture to show in my report. I have a tblpictures Field 1 pictureid Field 2 picturename Field 3 picture <-- this shows as a paperclip in table I have an attachment control with control source "SELECT tblpictures.picture.FileData FROM tblpictures WHERE...

Duane, I do not understand your response. I want to return all field2 values in table2, if field1 in table2 is contained in the classes field of table1. The classes field is a comma separated values field The autonumbers are irrelevant, except using for a where statement Chris

Thanks for the responses. I know how to use the code buttons but will look at how to use the Tgml for tables. MasterID1 and MasterID2 are autonumber for each table.

I know a little about querries but not complicated ones. I have 2 tables table1 masterid1 classes <-- This is a string field with comma seperated values tblclasses masterID2 field1 field2 <-- This is a string field that has comma seperated values a bunch of of other fields that are...

I know a little about querries but not complicated ones. I have 2 tables table1 masterid1 classes <-- This is a string field with comma seperated values tblclasses masterID2 field1 field2 <-- This is a string field that has comma seperated values a bunch of of other fields that are...

Yes but it did not generate anything.

I went to the updatecommand. Added new. command text UPDATE tblMSDS SET MasterMSDSID =, MSDSNo =, ProductNumber =, ProductName = Commandtype: text Now I am getting "sytax error in update statement" the error code line is...

I have it where it display all the information. I have not changed or modified anything (code or design layout) but get this error when modify a field and try to save "Update requires a valid updatecommand when passed datarow collection with modified rows" Private Sub...

Thanks for the reply. I will give it a try. However, it will be next week. I will post back with more questions I am sure. Chris

i would think you should loop through your entire page and then sort. This stops you from continuously sorting after each entry. Dim sx() As String 'strx change this to the info you want changed so possibly (rout(routrow,5)) strx = "nc,al,va,oh,va,nc" '(this was my example...

I am updating a program I wrote in VB5 to VB2008 express. I am trying to determine if when I update a dataset or a datatable do I have to write a update query or can I somehow link the textboxes/checkboxes/comboboxes to the fields in the table similarly to what was done in vb5. I have update...

If I understand correctly try this Sub tests() For counter = 19 To 30 If Application.CountA(Range(Cells(5, counter), Cells(49, counter))) > 0 Then Cells(5, counter) = 1 Else emptycol = counter counter = 30 End If...

I would think this would get closer to the desired outcome Sub EmailNotificationSent() Dim OutLookApp As Object Dim OutLookMailItem As Object Dim iCounter As Integer Dim MailDest As String Set OutLookApp = CreateObject("OutLook.application") For iCounter = 1...

Just a quick glance and without knowing what "is not working" shouldn't MailDest = "" be inside the loop so it resets after each email. Chris

Meant to say that the DBgrid only allows DAO connections and not ADO!!