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

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

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

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

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

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

Hi I am creating rent software and I would like to do a running balance in a report. In the table there is a field called amountPlus and amountMinus Record one might have $10 in amountPlus making the balance $10 Record two might have $30 in amountPlus making the balance $40 Record three might...

When closing an access database, I get the following error message: "There was a problem sending the command to a program" We recently had our server changed over. Is this an access problem, or their problem?

I am trying to use the runsql command and I am encountering a strange problem. The following works: DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" &...

I have searched (not knowing what to search for), tried Access help and most importantly experimented, but alas no luck. I have a header section and body/main section of a form. I want the background image to fill the body/main section only, but instead it seems to cover the whole form...

Not sure what to search for so I thought Id write a new post: I have a combo box which selects 3 items- Primary key, Surname, Firstname After an item is selected, the fields are populated according to the item. Since there will be many records, it would be nice if the user can begin typing...

I want a report that has 4 different sub reports. Each Subreport will have a total. Then on the main report, I want the total of all sub reports. Is there a way I can get at each subreport total, or should I code it or include the totals in the main table?

I have a program that works perfectly. It is in use, so I have done modifications on another copy of it. Tomorrow morning I want to copy those forms across. I did a trial run and I get an unusual error: "The expression OnActivate you entered as an event property setting produced the following...

Yes, this is an ASP question, but it is also an access question. I have finished a database, but it is more of an application. It is heavily reliant on visual basic and controls. I am happy with it, The manager thinks it should be a web page (??) I know ASP can interact with Access and be a...

I am annoyed by fields that start highlighted. ie: Name Address Postcode etc... And the first field when you enter the form is highlighted. That means pressing any key by accident when you enter the form deletes the value in the first field. Is there any way of ensuring no fields are...

No, this isnt about problems with my romance life. I am having strange date problems. The code is as follows: currpost = DLookup("currpostdate", "currpost") Do While 1 = 1 checkalloc = DLookup("allocationID", "allocation", "nightrent < #" & CDate(currpost) & "# AND status = 'current'")...

I have tried both the search function and google and I cant find anything that isnt overly technical, or helpful. What I want to do is: Begin Transaction do a do b do c End Transaction 'a' might contain coding consisting of while loops or if statements. Is this possible? In other words, I...

I want to do the following: If user enters dumb value Then Go back to the old value Else Do some code End If For example... Imagine there is a text field called city and currently has the city name If the user enters something, I want it to revert back to the name of the city that was...