Search results for query: *

That's what I ended up doing...created a new group, put that text box in the group all by itself and made sure that groups "Keep Together" property was Yes.

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

Here's my latest attempt: Private Sub cmdFilter_Click() If Me.NewRecord = False And Me.txtFilter <> "" Then intOldItem = Me.cboItemID Set rst = Me.Recordset strFilter = Me.txtFilter If Me.Recordset.Filter = 0 Then rst.Filter = strFilter...

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

what fields are in the table? Is there any code in the Form's Current Event? (the current event fires as soon as you reset the recordsource as you are above) The statement "as opposed to accessing it throught the recordset's name property" doesn't really make sense...can you clarify 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...

Unfortunately that only works if you want to insert the spaces at the end of the text you've entered. If you go back to the middle of your text and hit tab, it still appends the spaces to the end. I think I might just preface the code with a On Error Resume Next so that if windows starts...

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

Sweet monkeys!! It turned out the problem was that I didn't include the primary key of one of the join tables. As soon as I modified the stored procedure to add that field (tt.pkTOLtypes) to the query output, it was updateable.

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

All good suggestions I will explore further. Thanks. Another question for exploring ADO--which is generally the best strategy to use? setting a connection when the user first enters the database and then using that connection for each form, or have each form use its own connection? typically...

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

With a temp table it would be easy enough--i was just wondering if there was a way to do it without one.

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

I also like: dim db as DAO.database dim strSQL as string set db = currentdb strSQL = "UPDATE tblTable SET xxx=123, yyy=456.... WHERE pkID = " & me.controlWithQueryParameter & ";" db.execute strSQL,dbFailOnError debug.print db.recordsaffected 'code here to check how many records, etc. were...

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