Recent content by ck1999

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