Search results

Can you use the EOF property of the RecordSet? Dim con As Object Dim rs As Object Dim stSql As String Set con = Application.CurrentProject.Connection Set rs = CreateObject("ADODB.Recordset") sSQL = "select from barcodetable where barcode=" & barcode rs.Open stSql, con, 1 ' 1 = adOpenKeyset...

I did that and found one that will work in a pinch, but will ultimately be too slow as data gets poopulated, but for the time being it will do. If anyone has an answer I'd still like it because the built in "Search" capability is faster and closer to what my customer wants. :) just saw I...

You forgot the & in the last line possibly? " WHERE SQLACCESS.tblctwork.job_id = " & Forms!frmWorksOrderComplete.form!fsubWorderHead.form!txtjobid "

This is killing me... and so is my customer. I have set my application options default Find/Replace behavior to General Search. It works fine the first time the user does it. Thereafter, however, it reverts back to Look In: <specific field> and Match: Whole Field. Is it possible to make it...

You da bomb. Worked like a charm. Thanks.

For the life of me I can't get an input mask to work for date/time. I want to store flight times like this: Example: November 16, 2003 11:15 PM What mask do I use? The following isn't working: 00/00/00\ 00:00\ >;LL;0;" " I can't even directly enter the data into the table with no mask.

I tried putting it into a form to display as a datasheet. What I want to do is simple: 1) construct sql dynamically 2) display it for the user in a datasheet, allowing them to search. I tried just running it as a query but that has issues because I have no control over the menu for the query.

I created my own menu to attach to forms for my app. It looks fine on my computer, but everyone else has other menus too. Please tell me I don't have to set the menus on every single client...

Where should I put the code? Is it possible to put code into a query? Like in a query.onclose event?

I have an all-purpose query I display to the user on which they can filter/sort, etc. If they make any changes (filters, etc) it prompts them to save the query. Is it possible to avoid that prompt?

Never mind, I figured it out. I'm still somewhat new with Access. I removed the undesired functions from the "Query Datasheet" menu. I thought it was the same one as the "Query Design" menu.

I'm running a query from code and it pulls up the query window. But the menu allows the user into edit mode which I don't want them to be able to do. I'd like to be able to specify the menu just like I do on the forms.

Is it possible to get a query to use a customized menu like you can with forms?

Excellent. You just saved me a lot of work. Thanks!

Is it possible to export relationships from one database (development) and import them into another (test). I have to do it again on the move to production.

This is more basic than that. When I set the 'selected' attribute of the list box, the 'value' attribute remains the same. How do I get the bound value of the control?

I have a list box I'm requerying using code but the value doesn't change. "qryDelete" deletes the current row they have selected. str = Me.lstControl.Value DoCmd.OpenQuery "qryDelete" Me.lstControl.Requery Me.lstControl.Selected(0) = True str = Me.lstControl.Value The value of str doesn't...

Thanks, I figured as much and was already doing that as a work-around. I'm old enough to remember the days when there was no such thing as a tab control and I had to build them myself. Horrors... :)

I can't get my tab page to allow me to put another tab inside of it. What gives?

I forgot about that feature. I'm relatively new with Access. Thanks