Search results for query: *

I have an MS access report in which each record can have multiple images (each of which can vary in size depending on what the user wants although there are max limits set) and each image has its own caption. I've got the images to display correctly, but I'm having trouble with the caption--the...

I have a form with subform that is bound to an ADO recordset (Access 2003 to SQL Server 2008 R2). I have two buttons on the subform - one to apply a filter and one to remove it. At first, I was just using the following code to apply the filter: intOldItem = Me.cboItemID Set...

I have a report in which the detail section contains an Image frame (that is set to an image on the fly) and a text box for the image caption. They are arranged such that on the page they side by side, though typically the image is much bigger than the caption. The filename of the image and...

I have a form that uses the following code to open an ADO recordset to SQL Server: rst.Open strSQL, gCon, adOpenKeyset, adLockOptimistic When I use the .Update method I was getting the error "Row cannot be located for updating. Some values may have been changed" even though the recordset...

I am creating data for a chart. Each record in the end recordset needs to have a date and the number of open issues on that date (that I can then dump to excel for a chart). My strategy is to create a table variable populated with a record for each date within the desired range (an interval...

I have a plain text box on a form that the users can enter multiple lines of text into. I've done some searching around and it appears that you can't use the tab key to insert a tab into the field unless you use a rich text box (hassle--i was hoping you can change it's behavior like you can the...

I have a form that uses a stored procedure for its recordsource. When the form first opens I would like it to open to a new record, so I have it set up so when the form opens and gets it's recordset, it passes a parameter to the stored procedure that causes the stored procedure to return zero...

I finished creating a stored procedure for SQL Server 2008 that produces a recordset I'd like to use as the recordset for a form, but it's coming up read only. Private Sub UpdateFormRecordSource(Optional FormOpen As Boolean = 0) Dim rst As New ADODB.Recordset Dim cmd As New...

I've been tinkering around with an access database I have the task being to change the backend to sql server. I programmed a simple stored procedure that takes one parameter and runs a select query using that parameter in the where clause. Back in my front end, I want the results of the stored...

I have a crosstab query that I am trying to filter what is counted based on a subquery (TRANSFORM xxx SELECT xxx FROM xxx WHERE pkRevID In(Select xxx))... I've seen in other posts that you have to add a parameter if your pulling a criteria from a form, but I keep getting the "Microsoft Jet...

I'm creating a database that tracks open issues on a product. the data includes the date the issue was opened and the date it was closed. I am trying to figure out how to create a query that will return the number of open issues per day Simplified sample data: pkID DateOpened DateClosed 1...

It's pretty easy to assign someone else a task and set it so it keeps you updated as they make progress on it, but how do you do the opposite--assign yourself a task and then keep someone else updated on it? Creating a new task is easy enough and I assume you assign it to yourself by not...

Is there a way to specify incoming alert only on a specific folder within a document library? I've a document library that will have different folders for different groups within it and, of course, each group will only care about being notified when a document is added to its specific folder...

Is there a way to create a template for a document library--I've created a document library and customized it quite a bit and would like to use it as a template when creating a new document library. I'm using SharePoint 2003 and as much as I hate to admit it, am fairly new to it. Thanks, Jason

I have a form with the Active X Calendar object on it along with several controls that change the month/ year, etc. and it works great--as long as I'm logged on as a member of the admins group. As soon as I log on as someone else, the controls lock--I can still open the form but I can't click...

One form I'm working on requires a start time and stop time that will be used to find the number of hours a job took. Is there a way to enter the time in the format hhmm, e.g. without the colon? I tried using a mask, but even with that you have to enter the colon--it's only after you tab off...

Is there a site anywhere that describes all the docmd.runcommand constants? It seems that in Access help and on msdn only the value of the constants is given-- with no description of what each one does or how to use it. Any leads? Thanks,

I have four reports that are similar, but unrelated. My form currently has four command buttons--one to display each report which a user can then print. I'd like to make a single button that can be used to print all four reports. It appears that the best way to do this is to create an unbound...

I have created an mdb to track tasks and their completions. The current plan is to split it into a front and back end, and then store the back end on a network server here at work and distribute the front end to those who need it here at work. I will have user level security enabled, but there...

My current database has three form which all appear on startup. I currently use the docmd.movesize method to fix their size and position. The problem is when the database is loading, the normal database menus appear pushing the form position down. When it's done loading those menubars...