Search results

Good stuff How did you solve it? Me.cboSinger.Text I think the reason "Me.cboSinger" didn't work is that this tries to send a numeric value as the OpenArgs string, which causes an error. Not sure.

subQuery? This might be a silly suggestion, but you could try restricting the kit list so that only kits that haven't been ordered for the current house will show up. One way of doing this would be set the RowSource for LstKits to something like this - lstKits.RowSource = "SELECT kit_ID...

You might need to put some code on frmSingers If you want frmSingers to open with the new singer's name already in place, you could try this - Change your DoCmd.OpenForm so that it reads like this: DoCmd.OpenForm "frmSingers", , , , acFormAdd, acDialog, NewData Then put this code on the...

Try DCount? Hi Sam, Supposing that users will type the number you want to check into a textbox called "number_To_Check", and will then click on a button called “cmd_Check_Num”, you could try something like this (you’ll need to correct the code so as to match the names of the objects you’ve set...

Yep, your example is much better Martin Green's suggestion on http://www.fontstuff.com/access/acctut10.htm is daft. All those different tables. What a nuisance. It's much easier to keep lookup values in one table, then have some fields to identify the lists a value can show up in. If you...

Reference Problem The code you're using is for DAO recordsets. I think it's pretty likely the problem is that your project has a reference to ActiveX Data Objects 2.X Library as well as a reference to Microsoft DAO 3.6 Object Library. These are not compatible. Try this: In the VB project...

This might work Put this code in the place where you want to use the function: sum_to_target Me.A, Me.AA, Me.B, Me.BB, C Then paste the code below into a module and check it compiles Public Function sum_to_target(x_1 As Integer, L_1 As Integer, _ x_2 As...

I think this might be a usable work around It's a bit difficult getting this to work. One of the problems is that if you use a hidden ID column in a combo box, (Company_MemberID was hidden) then you're stuck with "Limit to List= Yes". Because of the hidden ID column (the bound column), "Limit...

Suggestion A possible cause of the error you’re getting is that your Select statements don’t seem to refer to your table “[tbl Clients]”. Also, I’m not sure that Form_Current is the best place to put the code you need. I’m guessing that your form is unbound (no underlying table) and that...

I've attached a nasty hack that might be useful Me!MyMessage = Me!WebBrowser0.Document.myform1.myfield1.value That's neat. I didn't know this was an option. Thanks. I'm guessing you want to get hold of values from input boxes without having to know their names. To do this nicely, you'll...

Public Sub? Why not try this: Instead of defining the routine on the master form as Private, define it as Public: Public Sub SubForm_RecordChanged(). You'll now be able to call this routine from the subform. e.g. on the subform's BeforeUpdate event you could insert the code...

Leave out call? As Pat says the syntax is correct. I wonder what's wrong? Usually, I don't bother with "Call", and just put btnNew_APP_Click If this doesn't work, and I guess it probably won't, you could try changing "Private Sub btnNew_APP_Click()" to "Public Sub btnNew_APP_Click()"...

You can do it with ordinary check boxes and a little code Hi Jenny, There are probably several ways of doing this. The only way I know however, involves some VB code. Here's what to do. First of all, you'll proably need to delete the option group and the controls inside it. Things often...

Example Here's a zip file with a spreadsheet and an Access 2000 database in it. I've been doing the sort of thing you're talking about for a while and there seem to be two main approaches. 1) Get Excel to open Access, then open the application you want, then the form you want, then navigate...

Filter by form Here you go: DoCmd.RunCommand acCmdFilterByForm If you paste this code into the click event for your button, that should do it.

Alias... "f" is being used as an alias for the table "users_Tbl". If you're designing a query in the normal way, the table is usually referenced by its name. However, you can change this in the Query design grid by right-clicking the table and choosing "Properties" from the popup menu...

Tricky One One of the things you could do is set up a query that converts dates into text values, then base your chart on that query. Set up a new query as you normally would and include all the fields from your results table. Then scroll to the first blank cell in the top row of the grid and...

Problem in Menu Selection Table The MenuSelection table needs to be restructured (quite difficult because relationships have been defined). It should be restructured something like this: ms_ID Autonmumber (primary key) Booking ID Number...

Your code works for me It's good code. And it worked for me. The only thing I can think of is that the problem might be that one of the eMail addresses in your list isn't correct and this is what's stopping things. Good luck with this.

Hope this will help. The multi-select form in the attached zipped access 2000 mdb does what you want I think. The boxes are multi-select, so users could hold the control key down to make multiple selections in each box. These will be "orred" in the resulting query. The code's a bit messy...