Search results

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

I want to run code when I change a page in the Tab Control object. The code I run depends on the page selected. I tried the 'On Click' code of the page, but that didnt seem to run when I clicked on the pages. The 'On Change' code of the Tab Control object seems to run whenever I change a page...

Do you mean CITRIX? CITRIX is a program which people use to dial into a server. All CITRIX users use that server. It is a seperate interface to their windows because thay are physically using the server. To set up a printer, the drivers need to be installed on the server, and then added as a...

I want to count the number of distinct dates in a table. Ie - So I know there were 80 requests over 5 days. The syntax I imagine is something like: myText = Dlookup("count(DISTINCT myDate)", "myTable") Can somebody please help. Thank you in advance

Thanks for your help. I am using the search function (as well as Google) as I type this, but I thought I would also ask you for advice: Currently I have a database that is all in one. This is a problem because if there is a bug or enhancement, I have to change the entire database (which could...

Hi guys. I have been told to make my database look 'sexier' but I am a bit worried that the pictures may slow it down or increase it's size unneccesarily. Speed is an issue because we have some offices that dial in and access it that way and as such are limited to their connection speed. So...