Search results

Thanks Pat, So just to see if I understand right, on a split form, the datasheet it displays is the form's control source datasheet. The thing with my form is that I want to use it to populate different tables. My first control was bound to the form's control source so when I wrote this...

Hi, I have trouble understanding this: I made a form that had as Record Source, a field from one of my database's table. Perhaps it was like that by default because I don't remember setting it myself. My form was properly functionning so far, but I decided change the Form's Record Source to...

Thanks Plog for the super fast and usefull reply! The double quotes didn't solve the problem by itself. Setting the SQL statement in a variable did help me solve my problem though. Here's the modified code: Private Sub txtGeoName_AfterUpdate() Dim strSQL As String DoCmd.RefreshRecord...

Hi, When the user enters a new city I used an after update event on the text box and the statement INSERT INTO to add the newly entered city to tblUniqLoc . Here's the code: Private Sub btnAddLocation_Click() Me.txtGeoName.Visible = True Me.txtGeoName.SetFocus DoCmd.GoToRecord , , acNewRec...

Ok, got it! I do not really know why, but here's the working code: Private Sub btnAddLocation_Click() Me.txtGeoName.Visible = True Me.txtGeoName.SetFocus DoCmd.GoToRecord , , acNewRec End Sub Instead of setting the GoToRecord function in the On Get Focus event of the text box...

Your right, I misstyped the text box in my previous post, it should have been: Me.txtGeoName But, as I wrote, my Enabled property is set to "Yes" on [txtGeoName] I need to mention that I am very new to VBA and Access, and I have to admit, I am having a hard time. A lot of...

Thanks for the reply JHB, The Enabled property is actually set to "Yes". Just to be sure that it really is when I use my form, I tried in the "on load" form event: Me.txtGeoLoc.Enabled = True What it did is turning the text box visible on form load, and I still get the exact same error...

Hi, On my form, I have a button that when clicked set a Text box visible and moves the focus to it. Here's the code: Private Sub btnAddLocation_Click() Me.txtGeoName.Visible = True Me.txtGeoName.SetFocus End Sub I get this error: Runtime error 2110, Access cannot move the focus to...

Hi, I think that a good way to start is by reading on data normalization. A lot of peoples suggested this to me and it changed my approach to database design. For your specific inquiry, I would go like this: Tables (fields): -Students (First name, last name, adress, phone, etc...)...

Thanks John Big Booty, very helpfull link. It's very similar to what I need to do. However, I still can't get my list box to update. Here's more info: Row source SQL code for my problematic list box: SELECT qyEquipement_Categories.EquipementID, qyEquipement_Categories.CategoriesID...

Hi, I have a form with a sub-form. The form displays some items, each items have a "category" attribute. One Item can be in more than one category, and I set this up using a many to many relationship. Now, on the sub-form, I have a list box which displays all the categories to choose from...

Hi all, Thanks to you all, I finally managed to have my combo boxes has I wanted them. I stuck with the initial VBA codeblock I had for the AfterUpdate event, and set the CB's row source to a query with an outer join between the tables I wanted the info from. The tricky part for me was...

Ok, since the names I want to display in my CB are in a table joined with the control source table, I was not able to solve this like you said. I read something about having a query as control source which would combine the info from the 2 tables. I also read about using the Lookup wizard to...

I still have an issue though, I cannot get the column with the names to display in my subsequent cascading combo boxes, only the ID. I've tried everything with the column count and width, which seem like a common mistake, but Access only shows blank columns beside the ID one. I then turned...

Hi, I'm new too, but I will try to help best I can: First I would create a query that regroup the information you need on your form sorted by school maybe. You can create a Split Form to have a datasheet and the input form in the same view, very practical. I hope this gets you a step...

That was it, Access tend to be a little frustrating sometimes for a non-programmer. Thanks again!

Hi, I have created some cascading comboboxes, using this tutorial: //blogannath.blogspot.ca/2011/04/microsoft-access-tips-tricks-cascading.html Worked like a charm. Lately, I decided to change the structure of my database, starting from scratch again, using plenty of related tables...

Re: Cascading comboboxes error? (Solved) Thanks again!

Cascading comboboxes error? - Resolved Hi pbaldy, It worked, I made the change like you said. At first the list items in my second CB were invisible; They were there and I could click on them, but I couldn't see them. I then googled: "Combo box list invisible" and after a while I figured...

Hi, I want to use cascading comboboxes on a form. When I try my form, Access return an error message: The record source 'PhyLoc FROM Location WHERE GeoLoc = 'Quebec City' ORDERED BY GeoLoc' specified on this form or report does not exist. I red some threads about it, and a lot of googling...