Recent content by yhgtbfk

I have a networked database. It is accessed with computers that have both Office 2002, and office 2003. I get the following error message on computers with Office 2003: "Object variable or With block variable not set" It happens occasionally and the problem generally fixes itself so I dont...

My advice would be to use visual basic in the after update code. If Date > StartDate AND Date < EndDate Then Date.BackColor = RGB(255, 0, 0) 'Set it to red Else Date.BackColor = RGB(0, 255, 0) 'Set it to green End If If you need the code to be run based on other things like the form first...

Ghudson do you mean delete the link to the images before deleting the buttons? Because I have deleted every form - taking with it all the images - yet it is still 12MB. I made a copy of the database and deleted absolutely everything - yet it is still 12MB. I wonder if access is hanging onto...

I had a database that was 25MB. Due to people changing their minds I have to delete an entire section of the database that took up nearly 1/3 of it. Yet I noticed that the space it occupies didnt go down much - even after a compact and repair. So I made a copy of the database and started...

I have a firstname field, and a surname field. On a report I have a textbox that is bound to =[firstname] & " " & [surname] This gives me an error. I have even tried single quotes, but no luck. Please advise Thank you in advance

Not sure entirely what you mean, but this may help. myValue = planned + delayed If myValue >= 60 then planned = 60 delayed = myvalue - 60 Else planned = myvalue delayed = 0 End If

That worked perfectly Thank you

Hi guys Im trying to set my label to a string. Something like myLabel.caption = StringOne & chr(13) & StringTwo The problem is I just get funny symbols instead of the carriage return. Please help Thank you in advance

SAD Black & White Game Sound File (Electronic Arts, Inc.) SAD Fast Atomic Density Evaluator File SAD Serveron Analyzer Data File SAD MultiEx Commander Set-up Cabinet (XeNTaX) http://filext.com/alphalist.php?extstart=%5ES

Not knowing too much about ASP, I'll say that it reads the picture string and inserts an image based on it. The best thing you can do is create an 'image not available' picture, and use it as the picture for those products without pictures. So all pictures should have a check box, but those...

This might be obvious but I am am going to ask anyway - did you try right clicking the database and going to properties to make sure 'read only' is not selected? Another thing is you may have set up security that gives write access to certain profiles only. However I can rule this out because...

Maybe you can use VB coding attached to a button to get data automatically. The dlookup function allows you to get a value from the table based on criteria. The onclick code can be something like: Private Sub myCommand_Click() On Error GoTo Err_myCommand_Click Dim myValue 'The value of the...

I have done alot of search on the forums and cant quite find the answer. Is it possible to have the user tell the FE database the file path of the BE and then have code run automatically to refresh the links? I have a database that I want to lock all users out of. Yet the FE can be located...

I still have my database as one single application and I am worried because there seems to be alot of people who split the database. Maybe by not having a split database I am doing things the wrong way, or the old way, or maybe I am compromising my databases. From what I can gather, linked...

Thank you so much