Microsoft Access / VBA Forum

I have an off-the-shelf app that uses an Access database as its backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some reports against this database, and I believe this field contains data I need. When I view the table in datasheet view, all I can see in this field is the string "Long binary data". ...

Hi all, I need to determine the name of the primary key in a table, but this must be done using VBA. I was looking for something like, for each field in someRecordset.fields if field.type="primaryKey" then do something

I have a form that allows the user to selct items from a listbox and combo box. how do I reset them ready for the next set of entries. I thought I would have a clear button. regards in advance. Peter

Hi folks, Can someone point me to some resources on how to control FTP sessions from and Access application with VBA? Many thanks for all help. --LW.

Hi. I have Access 2003 and I am finding that the font in the text displayed in Msgbox displays it too small. Is there anyway to increase the font size of that text? Regards, SueB *** Sent via Developersdex http://www.developersdex.com ***

Good afternoon, I am having troubles with an insert into statement in Access 2002 that I am performing through VBA. I am inserting a single record into a table with one yes/no field. For some reason, I cannot seem to set the boolean to yes. Here are the various strings I have tried: "INSERT INTO tblWorkOrderPartRequirements (WorkOrderID,...

I have a memo field in a report that is truncating at 255 characters. I've tried the following w/no success: 1. Grow/Shrink option is yes. 2. "Group By" changed to "first". 3. "Group by" changed to "last" 4. took out memo field, saved query, and reinserted memo field. nothing seems to be fixing this bug. Please help! any suggestions are...

I know this topic is a veritable dead horse, but I have to ask, because I am unable to find something that is close to my scenario that I can completely understand. I have a start date field and complete date field. I need to know how many days, minus holidays and weekends are between the two dates. i already have the table of holidays...

Hi There, Im having a bit of a problem tryin to get my subform to automatically stretch to the size of the detail section when the main form changes size. I have set the autoresize on both the main and subforms along with the can grow/shrink settings. I also tried some code which almost worked on the onload event on the main form. ...

The motivation for this Tip was a question asked by one of our Resident Experts, FishVal. The question was: How to Declare Default Method/Property in a Class Module? My response to the question was inadequate to say the least, but I was determined to come up with the correct answer, especially since my primary background is Visual Basic, and I...

I've figured out how to insert subdatasheets into tables and queries - just open the table/query, select subdatasheet from the Insert menu, and play around with the Link Child/Link Master fields until you get what you're looking for. Easy enough. But how do I use these in my forms? I tried dragging a table with a subdatasheet directly...

I am trying to combine forename and surname together in a report so, that there is only a single space between the two. Any help would be much appreciated. hope someone can help me with this problem. Thanks

Is it possiable to have a iif function in a query where it looks at the next record. for example if I run the query which lists years and if the results in record 2 equals the result in record 1 then it displays an X.

I have a fairly large access 2003 table (200,000) records. Field 'X' is a text field, and contains either no value, 4 digits, 5 digits, or 6 digits. What I need to do is to add two zeros to the left of the records with 4 digits in field 'X', 1 zero to the left of the records with 5 digits in field 'X', and 6 digits for nulls. IE, record 1...

I'm using Access 2003. I have a List Box which I populate by selecting items from a drop down Combo Box. I now want to delete from the List Box only the selected, but not necessarily sequencial items (either one at a time or several). I found some code at this website: http://www.599cd.com/tips/access/listbox-additem-2000/ The author...

This feels like a really dumb question. I have a very long SQL delete statement in my code. I would like to make it readable but if I put a carriage return in there it screws up my code. It wants it all on one line. What kind of special character do I have to put in there to show it's continuous? I tried \n and /n but neither worked. Thanks!

Well, it has finally happened. We have a five year old app that is widely distributed. I cannot get an update done because none of the code modules will open. Access complains that the module is corrupt or that it cannot be read from a network drive. They are not ON a network drive. Anyone have a clue how to repair this? All help...

I have a command button on a continuous subform and I want the user to click it to open a small popup form that opens in the position of the mouse (which is the same as the position of the command button on each record of the continuous subform.) I'm hoping someone can tell me how to do this. Thanks, lq

Hello, I'm trying to work with multiple databases (for different Fiscal Years) from within a single database. I have two backend dbs I need to pull up data from at different times, depending on which fiscal year the user selects. So I want to use in the vba code, set db to a database other than CurrentDB. If one of my other databases is named,...

Gang - Is it possible to change a string such as "11/28/2006 11:30 AM" to a valid date/time format in Accces? Mike

Hello all I have multiple forms, these form interact with each others using buttons. I want to close Form A everytime I click on a button to open Form B. So i dont have multiple forms open at the same time. I know the code, to close the form, needs to be put under the On Click Event button that opens the next form, but dont know how to...

I am wondering how you can change the fontcolor in the header or footer in VBA when exporting to excel. I need some text in red. I found the ms page with the codes here. It's saying the formatting is &color and it should be a hexadecimal value. Then on the bottom of the page it says K. I've tried a lot of things like: &Kff0000 &K &ff0000 &...

In my SQL I have a column that returns a boolean value (-1 or 0), no problem. I need to be able to only see the records that return a 0 (False). I can sort and bring these to the top. When I attempt to create a criteria on the QBE or filter (right click menu), I am confronted with a ""This expression is typed incorrectly, or is too...

I have a macro that does a few things to an Excel workbook and then saves, and closes to an Excel workbook. I now want to save, close the Excel workbook as a text (tab delimited .txt) file. Currently I am closing/saving the file near the end of my Sub with: wbResults.Close SaveChanges:=True Dim wbResults As Workbook...at the beggining of...

I want to use SQL code to Create a Table & Provide a Default Value for Each Column. Here is the code I am using: CREATE TABLE customer (First_Name char(50), Last_Name char(50), Address char(50) default 'Unknown', City char(50) default 'Mumbai',