Search results

Thanks very much! This is how I have it: dim var1 as string var1 = "PUT A LONG LONG THING HERE" when I look at the var1 under watches, it doesn't show the whole thing

Umm.... I'm not doing anything to it right now. If I just have a string, and assign it a value: eg. dim str1 as string str1 = "[something 252 characters]" It doesn't hold anything past the first 252 characters....

I have a string right now which needs to hold about 1000 characters or so. But, VBA limits it to only 255 characters. What can I do to make it hold more? (the string holds a SQL string which then gets passed to: db.openrecordset(sqlstr, dbopensnapshot) Thanks

Is there anyway to get around it....it's blowing up my app right now :(

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?

Oh ok that works on one field. But, in another field, in the query, I have a dot in the name of the field, eg. it's data.Pri What should I do in that case? Thanks!

Thanks for the link, but I still can't seem to get it to work. Here's what I'm doing: Me.RecordSource![ID] and it's not working...

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.

How can I set my application to close when the switchboard closes? Could you give an example? Thanks!! This code looks really good.

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.

How can I hide the form? Is there any vba code for that? Thanks.

But those are it, right?

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