Recent content by jiblankman

Although there were no responses to this question, I did figure out how to make it work. If anyone else is interested, here is the code that I used. I am sure there are other/better ways to do this, but it works nicely and quickly. I placed the code into the Form_Current and Panel_LostFocus...

I am trying to make a form that is user friendly and easy to expand. I have the following table: [Panels] PanelNo - unique number CatA - yes/no CatB - yes/no CatC - yes/no PanelNo 1 = CatA CatB PanelNo 2 = CatA CatC PanelNo 3 = CatA CatB CatC I have fields on a form for each of...

I figured out the last problem. The format function was causing the error, not the date() function. Somehow I lost connection fo the Data Formatting Object Library. I re-referenced it works fine now. Thanks all for your help.

Thanks Chris, that works for the tables. I still can't get the report date to show properly. I just tried to create a new unbound textbox with the control source =format(date(),"mmmm yyyy") I cannot even press enter or click in another field after typing this. I can still delete what is...

Hi all. Thanks for such quick responses. Unfortunately, the full situation here is hard to explain, but in short, we need to pull data from multiple dbs, pool selected data from them, select random records from the pooled data. The selected records are temporarily stored in a new table (no...

I am having two problems with the Date function. I am using Access 2003. Hopefully someone has some idea what happened and can help. First problem: I have a table and need to add a column with the current date. The following has worked perfectly for 2 years, until today...

Never mind. I figured out what I messed up and corrected the SQL. Thanks for your help, this was an interesting learning experience and a success. My DB went from 114MB to about 650 kb with a 2.5 MB folder of images. The images load faster, especially for some of the higher resolution ones...

I must be doing something wrong. I have the following query: SELECT Articles.ID, Articles.ProjectName, Articles.MagazineTitle, [ImagePath] AS Expr1, [ImageFile] AS Expr2 FROM Articles WHERE ((([ImagePath])="Magazine Index Images\Record") AND (([ImageFile])=[ImagePath] & [ID] & ".jpg"))...

Ok. I removed all of the images from the database and see a dramatic difference in size. It went from 114MB to 500 kb. I now have a folder in the same directory as the database. The folder contains files named like "image1.jpg", etc. Image1 is the image that should be displayed with the...

Thanks for the help. I am in the process of removing the images from the database and creating individual jpgs. I will need to learn about imagecontrols as i have never used them. I will post my results when completed.

I have the database set to compact and repair on close. I have been copying and pasting the images into the database. That is probably the problem. I will look into using a link instead. Thanks for the suggestion. Is there a way to automatically generate the link path for new records...

I have been making a personal database to catalog articles I want to save from a number of woodworking magazines. The DB is fairly simple but I cannot attach it due to the size. There are three tables; three forms linked to the tables; and some reports. I want to include a picture of each of the...

Wayne and Richard, Thanks for the help and suggestions. I changed the way I was approaching the issue and worked it out. Although I am still unsure why the original way was not working. It made no difference whether the randomize statement was used. Weird. In the end I created another...

Yes, I used the shuffly button. But if you start from the original table each time you open the database, you get the same first shuffle. This is what is happening in my database. I have to create the pool of employees from several other databases so the table nearly always looks the same...

Richard, Thanks for the link, that is an interesting problem with a very fast solution. Unfortunately, it still suffers from the same problem. The first sort (when starting from the ordered deck) always has the 8 of hearts first. I edited the VBA to insert the "Randomize" command before...