Search results

Hi, I have a form with several multi column listboxes, these are populated using a query supplying the top 1 record from a table (based on some criteria). They work fine but when I added a button (for each list box) to open a detailed form to edit the data from the record I ran into problems...

Hi, Sorry for the terrible post, I didn't preview it and I couldn't get the code working, I realised I'd not enabled the javascript for the site. (new PC) I hope this is better, this code stops the form from operating. Private Sub Toggle7_Click() ' Filter on workstaions only in listbox...

Hi, Thanks for replying, there are records for each query and they were working when I added them. This one works: Private Sub Toggle5_Click() ' Laptops Me.List0.RowSource = "SELECT [PC Details].ID, [PC Details].[PC ID], [PC Details].[PC Type], [PC Details].[SAP No], alphalist.first_name...

Hi, Ive got a form with a list box and I redifine the rowsource in VBA using several toggle buttons. Everything worked fine then all of a sudden when any 3 (same 3) of the 5 toggle buttons were used the form would no longer work. When ever any area on the form or toggle button was pressed the...

Thanks for the info, I will only need to run this code every 6 months so I don't mind overriding the Outlook security for 5 minutes every 6 months. Cheers.

Hi, I'm able to send emails using code, thanks. Unfortunately I get a windows message warning that a virus may be trying to send an email and I have to wait several seconds before the YES button appears, I've got about 120 emails that will be sent, can I get around this ??? Cheers

Yep! tried most of that already, post 3 shows the debug.print of the strSQL which shows text30 had the date in it. Cheers

[Text30] is an unbound text box that gets todays date put in it when the form loads. When the filter is applied it filters using the [test status] = ..... but ignores the date part.

"not started" is valid, the filter actually applies that part to the form but doesn't apply the second part, the date < today. The really annoying thing is that when I originally deployed this code it worked...... now it doesn't ????????

Thanks for the tidy up info, it's obvious when you see it, I just copied code from a previous project and edited, I'll read it properly in future. I tried your suggestion but still no joy, I've given up now an redone it as a form with a Tab control and on each tab a different sub form each with...

When I created the new test query I needed to filter by Project, this was allready done in the original form by its source data query, using the same table data as the test query. I also tried binding the original form (the one that doesn't work) to the unfiltered table and adding the project...

Thanks, I tried this but I can't find a fault, just that it does not filter correctly, the debug print: [test status]= 'not started' AND [planned finish date] < #10/03/2008# This should work but it doesn't. I tried a query on the table and typed in "not started" and <#10/03/2008# in the query...

I've got a form with a button that applies a filter to limit the list to records that meet certain criteria, date and status. This code worked! but now it won't can any one see what I'm doing wrong. Me.Filter = "[test status]= '" & "not started" & "'" & " AND " & "[planned finish date] < #" &...

You're very welcome.

When you added the button the wizard should have asked you what you wanted to do and you then select Frm_dietInfo or whatever you called the form then it would ask you if you want to display specific data or all data, if you select specific data then you get a dialog that asks you to select the...

jgamlin777, I may not understand exactly what you're trying to do but whenever you open a form using the button wizard it will ask you what field you want to use to open the form, if you want to call the other form without pressing a button then copy and paste the code from the button click...

Hi, I trying to duplicate some records displayed in a form after being filtered and I'm doing this using VBA: ' Change form to allow additional records Me.AllowAdditions = True 'Select all record in filtered view and paste append to table/form RunCommand acCmdSelectAllRecords...

jdraw, Thanks for the code, I wasn't looking for that function but I can definately use it. Cheers, Gadjet

I can only partly answer this, you can define the startup form within Access and get that to autocenter on opening but I don't think you can hide the other stuff, I would make a startup form that was maximised on open but looked like it was a smaller form in the middle. or startup with a blank...

Thanks Linq, Works like a charm. Not quite as nice looking as a button but it does the job. Thanks Gadjet