Recent content by cawillwe

I can't even see the photo when I go back in. Also, is there some other way to browse and get the file in correctly? Unfortunately, I don't have enough confidence in my users to say "just copy and paste it in there" to be able to use that.

I know JPGs are a pain to work with in Access, but that's all I have to work with. I have a table as follows: ID: Autonumber Object: OLE Object And I created a form based on this table, with a bound object frame pointing to Object. When I choose insert object and choose a .jpg, it own't...

I need to be able to check to see if Outlook is open, and then if it isn't open it. I need to actually open the program, not just an instance of the class (unless I'm issing something here). Any ideas on how that can be done?

I have a button set to open a report and place a filter on it. It is not displaying the correct records, but it is also not displaying the same records each time. The query the Report is based on looks something like this: SELECT DISTINCTROW BackupRevised.CUST, BackupRevised.CTRL...

I have records that have children in another table and I would like to be able to concatenate the string in one field in a query: Table A: tblA_ID FieldA1 FieldA2 Table B: tblB_ID tblA_ID FieldB1 Now say I have in Table A: tblA_ID FieldA1 FieldA2 1 abcd efgh and in Table B: tblB_ID tblA_ID...

I have records that have children in another table and I would like to be able to concatenate the string in one field in a query: Table A: tblA_ID FieldA1 FieldA2 Table B: tblB_ID tblA_ID FieldB1 Now say I have in Table A: tblA_ID FieldA1 FieldA2 1 abcd efgh...

Naturally, 2 minutes after I posted this I found a good reference msdn.com: http://msdn.microsoft.com/library/periodic/period01/ino2k.htm Sorry if anyone already started this.

I should mention that the reason it checks for Left(Forms(i).Name,9) is to exclude the forms "frmSearch" and "frmSearches," which I have created in the database.

I'm trying to get 2 combo boxes to populate: 1. Has a list of all tables and queries in the database 2. Has a list of all forms The first one is working, but may be a little sloppy: Me.TableName.RowSource = "" For Each tabledef In CurrentDb().TableDefs If Left(tabledef.Name, 4) <>...

Thanks for the help guys. I'm trying to add things to existing forms, so a template wouldn't help in this case, but I'll keep it in mind for the future and I use one for searching already. Wouldn't it be great if you could do it simply though? Oh well.

I'm looking to save a little time when I copy certain buttons from one database's form to another. These buttons have code attached, but when I copy, the code doesn't come with it. I have to go into the vb editor and copy the code, and then go back and set all the proper events back to "[Event...

I figured this out on my own, as below: I wrote a function in a module, called CheckNull, which was written as follows: If IsNull(str) Or IsEmpty(str) Or str = "" Then CheckNull = strNull Else CheckNull = str End If Then, for my rowsource, I used ...