Search results

I'm encountering a problem when exporting query data. I need to create flat clean textfiles of compiled data for use by other parties. Some of the data is held in Long Text (memo) fields, and is generally verbose text with some RTF underlining or BOLDfacing. I use an action query to create...

I’m simplifying this question for brevity. The real database is more complex, but I can apply a viable answer to my database. I have created a database with several of tables, such as NAME, TASK, CATEGORY. I have a main display query which selects a collection of data taken from those tables...

Greetings all. I want to make a chart and I can't see how to accomplish what I want. I'm seeking suggestions about the best approach. I have a query with a list of selected names which I want to use. I have a query with a list of events. Each event has a start time and end time field, and the...

On a form called "MainLarge" I have a field from my table called "Tag," which is Boolean. I want a public subroutine to process the state of that field with the following code (truncated here for simplicity). The MainLarge form is open when the subroutine is called. Sub ToggleTag() Dim...

I would like to create a form with a selecting matrix. One set of records as Column Headers and one set of records as Row Headers, with a grid of checkboxes at the intersections. The user could check or uncheck those boxes, and I would then like to select data which has coincidental checks. As...

Does anyone have a template for an API call to the ChooseFont of Windows Common Dialog? I've searched everywhere I can think of and have only encountered examples which don't really work. I can get the OpenFile and SaveFile to work, but I can find next-to-nothing on ChooseFont.

I have an application with a custom-built ribbon which includes keytips for the tabs and for buttons in groups in those tabs. The first time that I use the keytips after starting-up the application, the keytip letters for the tabs show up after typing 'Alt,' but the letters DO NOT show up when...

I thought this would be easy, but my brain doesn't seem to grasp the concept... I have a number of forms, each of which has an invisible label with the same name (DoneLabel). From time to time I would like to make that label visible for a second or so, then make it invisible. The operative...

I'm trying to add my own images to buttons I'm adding to a custom ribbon in Access 2007. I've done fine adding .jpg or .bmp images, but I would like to utilize transparencies for these images so they'll look pretty. Although Microsoft's MSDN information says to use .png files, they don't...

Greetings from a Luddite. My WinXP laptop died- again- and I'm going to have to replace it. Has anyone experience with running Access 97 on Vista? There's all these different incarnations of Vista too, so please note which one you've used. I don't want to stay too far back on operating...

I'm trying to create a menu item which changes a property on the currently-active form. I would like the code to work on whichever form might be currently active. I can easily put a button on a form which changes the property, but I'm lost when it gets to trying to address the form's property...

Greetings I know this is kind of a basic question, but I'm having trouble finding the answer. Does it matter how an If / Endif block is exited? Would the following code cause problems when executed a lot of times? I'm concerned that when condition1 and condition2 are true, I'm exiting both...

Is there a way to determine if at any moment a combo box is in the dropped-down state or not? I've got code which redirects keystrokes, and I'd like to have it not re-direct up- and down- arrows when a combo box is dropped down so that the combo box appears to function normally, but I don't...

How hard can this be? But I'm stumped. A very simple query that should pull up fields with zero-length, to be used in cleaning up the database: SELECT Characters.CharName, Characters.* FROM Characters WHERE (((Characters.CharName)="")); Running Access 2007, I receive an 'Invalid Argument'...

I've been perfectly happy with Access97 and WindowsXP. But my laptop's circuitboards have deteriorated, and I need a new computer. I'm wondering what the real-world has to say about using Access 97 with Windows Vista. Does it run seemlessly? Please say yes. I have an application which I've...

I'm working with a split database. I frequently change the b/e link to different .mdb files. Sometimes it's because I'm debugging or testing changes to the front end, sometimes it's because I'm working with data from different projects. I thought it would be nice if I could display the name...

Greetings, all. I have two combo-boxes in the header of a form. The form appears as a window (Not full screen). The values of the combo-boxes are set on open, but when the form opens, they appear to be blank. But they only appear blank. If I click on one, it's value appears. If I move...

I am about to upgrade to a new computer, and therefore a new operating system. Question is, will Access97 run OK on Windows XP Professional. Is there anything I must look out for. I'm hoping to not have to change to Access2002 right now, as I'm about to begin a big new project which requires...

Greetings to all I've searched and hunted and experimented, but to no avail... From a pop-up form, I would like to update the property of a label on one of several other forms. The circumstances of the moment will determine which form's label is getting updated. I can't figure out how to...

I'm, trying to make a query work which searches for one or more keywords. The form which calls the query has an input textbox. I have code which strips and parses this input and concatenates it into a string with asterisks, etc. If the input textbox contains dog bark loud the string ends...