Search results for query: *

So I've had this relationship with MS-Access for over a decade. It was causal at first, I'd see her a few days here and there on certain projects. Later on it became more serious as I stopped seeing other platforms and developed in Access exclusively... However the relationship has lost it's...

Hi. Any help is appreciated. I'm trying to print a report with some records having images and others not. When no image, there should be no space between records. That is, shrink the detail when no image. I have the following code: Private Sub Detail_Format(Cancel As Integer, FormatCount...

Hi. Thanks for looking into this. Any help is appreciated. I have a form and every time the user clicks on a new tab, the record source of the table changes. However, in the VBA I cannot reference the field. It only shows the fields from the original record source. When I type it in anyway...

Hi folks. Any help is appreciated. I'm trying to change the control source of an image in the VBA however it doesn't show up in the list/properties dropdown when I type in me.imgNarrative. The Control Source exists in the properties window on the form just not in the VBA. Any clues as to...

Hi. Any help is appreciated. I have two tables in my database that use the attachment data type as one of the fields/colums. The problem is that every time an attachment is added the size of the database increases by the size of the attachment. This quickly turns the database from a 1 mb...

Hi. Any help is appreciated. For some strange reason my fields move around on the report when I try to move them with the mouse. It'll move up about an inch and center itself. I then have to drag it back down to the position I want it to be on the report. This is, to say the least, rather...

Hi. Thanks for looking into this. As with any thread, please only reply after reading carefully. Also only if you are sure of the correct answer. No one likes to read a bunch useless posts before getting to the right answer. Especially when they have to read more than one post. In the...

Hi. Thanks for looking at this. Please read this (and all questions) carefully before replying. Thanks. I'm trying to set subform visible property to false from event of command button that exists inside of subform. I'm getting "2165 You can't hide a control that has the focus". And yes...

Hi. Thanks for your help. How do I sort the value list in a listbox? It seems there should be a sort property but there isn't. Thanks -Nima

Hi. Thanks in advance for any help. A table column name was changed. Is there a simple way of changing, at once, all the column names used in the report text boxes? Something akin to the find and replace feature in other apps. FYI, the control source of the text boxes combine columns and...

Hi, thanks for looking at this. How do I print a sub-report only on new record? Details: Printing mass mailing to our members. Only first page of each mailing page (ie new record) should contain the address. The envelopes have windows and naturally the address should only be printed on first...

For some reason my y-axis disappeared. When it's in design mode I see it but when in report view or print view it's gone. It was there before. Any ideas? Thanks, Nima -Nima

Hi, I'm trying to set the current database to Dev. Using this: SET DATABASE TO Dev; Getting this: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'DATABASE'. The code I use is copied from the msdn page exactly as they have save for the database name of course. Any...

Can anyone help shed some light. I got an alert from Norton saying an intrusion attempt by (gives attackers IP address) was blocked. I'm thinking it might not be an attack because the attackers IP is almost identical to mine. The only difference is that it ends in a 1 and mine ends in 4. It...

Hi. There are some threads for this but I wanted one that's still open. Can anyone recommend a good book on VB.net programming? I'm an Access programmer with the vba/vb6 experience needed to program in it. I haven't used OOP before but I dont' think it'll be a big deal to pick up. I need a...

Hey, I used to find work in LA as an MS-Access programmer with fair ease. Now it seems there are no contracts to be found anywhere. I've had a few calls with no real results. Anyone else? Any advice? Any leads? Thanks -Nima

Hi. I have a cat5 cable installed throughout the house but of the available 4 pairs one is being used for the phone. Can I successfully install keystone jacks and connect my computer to a network router at another end with three pairs? My roommate says I only need one pair but I'm not sure...

Hi. Thanks for looking at this. I have a Viewsonic P225 pro series monitor with 5 BNC connectors in the back (Red, Green, Blue, H-Sync and V-Sync). I have recently acquired an old Laser Disc player with an S-Video out plug. How do I connect it to my monitor? I've seen connector to RCA...

Hi, Any help on this is appreciated. What's a good way to have a report that looks like this: Category Detail ----------------------- Vehicle Ford Focus Vehicle Honda Civic Vehicle Mercedes C220 look like the following? Thanks. Category Detail ----------------------- Vehicle Ford...

Hi and thanks any help on this. I have ADO code that opens an excel file and imports into an Access table. This works fine on every excel file being imported except for one for which I get this error message: Run-time error: '-2147467259 (8004005)': External table is not in the expected...