Search results

Max length of a string? I have a string in VBA (it's dim as string), and it's truncating everything longer than 252 characters or so... Is there a length limit on a string?

My form's control data is currently linked to a query. I'm trying to use vba to get information about the fields in the current record. I think it's supposed to be: Forms!Form1. (something here?) But I just can't seem to figure it. What code am I supposed to use? Thanks!

I'm using Access 2007 (doesn't seem to happen in 03). When I have my form in design view, I'm trying to make it a small, 400 by 400 pixels form. When I open it up in the view view, Access adds a LOT of space to the left and the bottom of the form, even though nothing is there. What should I do...

How can I get the scrollbar position of a subform (which is inside of a form)? It already has the scrollbar on the side. The subform is just populated with text, not records. I just don't know what code to use to determine the position of the scrollbar (I want to find out when it reaches the...

In my DB right now, I use some vba code to export my report into a .RTF (using the standard vba for that). It works great in Access 2003, but when I do it Access 2007, Access locks up, as in, it doesn't give me a "end now" dialog, but it doesn't let me click on anything. What I found out was...

Is there a way to add a button which would automatically compact and repair my current database? Thanks.

Uh oh...How can I explain it? So I was following this tutorial: http://www.access-programmers.co.uk/forums/showthread.php?t=97578 And now I lost my file menu bar for good. I mean I totally can't get it. I'm going into the customize menu, and I can't find "File" there, I'm right clicking, but...

What VBA code should I use to hide the tool bars, menus, etc.? I'd like to make it as minimal (only showing forms) as possible. I know I can't hide the access window, but I'd like to hide as much as I can.

When I open my report ( I open in in pop-up mode on, and modal on), it doesn't have focus. Are there any properties, or any code I can use inorder to give focus to the report on load? Thanks.

I heard for good database practices, whenever you're done with opening and using a database, you should close the connection. So if I have an example connection like this, are the statements at the end enough? dim db as database dim rs as recordset set db = current db dim strSQL as string...

I'm trying to hide an image on the report, but when I do, in the preview, it gives me a lot of empty space. Is there any way which I can hide or remove the empty space? I know for text boxes, there's a property: can shrink = yes, but it seems that's not available for images. Each of my images...

Hi! Let me describe my situation first, just to give you guys a clear view of what I'm doing. My database has links to upto 6 image files(each taking up the whole page, 8.5 by 11), per record. I'm trying to provide an interface for my users to view the image files, so I made a report, which...

How can you set focus to a report on load? Right now, once it loads it does not have focus. Thanks!!

Hi! How can I execute a .bat file, and open it up, after clicking a button?Thanks!

I currently have an acess form with a tabcontrol which has 5 tabs. It sits over an image currently. Whenever I change the tab, or I move my mouse over the tab page, the screen over the tab page flickers, and I can see through to the image often, and it does wierd flickering effects like that. Do...

How can you count the # of recordset? I tried using (rs is my recordset). Everything is populated into the rs and it works. In order to count the # of records, now I'm using a do while not eof, and it's working, but i'm wondering, is there as alternate way to find the # of records in rs? I...

I've been searching all over this forum, and I found this really neat link(read from post 17 down): http://www.access-programmers.co.uk/forums/showthread.php?t=28702&page=2 Which shows how exactly you can get in id3 info from mp3s into a database. But the problem is when I try to use it, I am...

I have 8 fields right now: field1, field2, ... I want to make it so that if, and only if field1 is > 0 then it will display field2, and so on and so forth, so that a field is only displayed if the one before it is filled. How can I do that? Do I need to make a TON of if loops, or is there a way...

I'm trying to set the control source of a text box, but I don't know the syntax for it. me.txtLabel.controlsource That's as much as I have. I need it's control source to be set to the 3rd record in a table "file". That table isn't the form's record source. How can I do that? Thanks.

Hi! I have a few objects: txtLabel1 txtLabel2 txtLabel3 . . . They're all are incrementing in that order, so is there a way I can do the me.txtLabel[number here], through a variable. so, for example, var_num = 3 me.txtLabel + var_num (except that doesn't work) How can I do that? Thanks.