Search results

It failed again. The record the user is on is 17114. When I download a copy of their data and pull up the same primary key, it is record 17115. Shadowing the user, I saw again how changing the data actually changes the values for the previous record. The record pointer is off somehow. I was...

The combo box is likely bound to the employee id number. That is a good thing. If you want the name to show up in the subform, then you will have to display it. You can hide the id field if you like. It sounds like you are equating the name to the pull down list which is bound to the id...

put missinglinq's disable editing code into the onLoad of the addnewrecord form, or set the addnewrecord form's data entry record property manually and save the form. You will need two buttons: one for enabling edit and another for disabling.

Add a button to your form called search. In the onclick event of that button, put in the following vba code: docmd.openform "frmSearch" Replace frmSearch with the name of your search form. I often use pull down lists for searching by key fields. Once they pick a value from the list, you can...

I tried it and it worked fine. The top form is unfiltered where the bottom only shows the one value: The box in the footer of the sub form has =Sum([amt]) as its control source.

You can set the table property of Required to yes for all the necessary fields. John M Reynolds

A login screen is a simple form with one or two unbound textboxes. How it works depends on where the user and password data is kept be it in a table or be it hardcoded. On the Password field, put the word Password into the input mask property. John M Reynolds

set the size in design view and set it to autoresize and autocenter. Remove your docmd and let it do it all for you, so it will work consistantly. John M Reynolds

If you are on citrix, then give everyone their own home directory and put the front end(s) in there. As long as they each have their own copy, you should be good. As well, giving them an updated version of the front end may sort out any corruption errors. John M Reynolds

That is a very limited way of going about doing an order form. Start with the tables and relationships. Then go onto designing the forms. The best idea is to get a book or take a class, since no one would be willing to walk you through such a large task over a forum. John M Reynolds

Try using =Sum([AmountField]) as your total field in the form footer. John M Reynolds

on click use the docmd.openform "StoreHistory",,,,,"StoreNumber=" & StoreNumber I don't remember how many commas are needed, but that last bit should be in the filter section. John M Reynolds

The list of players is the easy part. getting the player's information to show is harder since a list (tabular) form cannot have a subform. I would get the program to pull up a separate form to show the player's information. Start by making all 3 forms then drag and drop the players list to...

1 - It allows me to select any of the 3 items in the ProblemaID subform. I can select them as many times as I like. It also allows me to select 1,2 or 3 for the subSistemasYProblemasAnteriores subform. I don't understand what the problem is. 2 - Your column count is 1 and you are set to...

After update of the first box, enable and requery the second box. John M Reynolds

I think this is what you are looking for: SELECT tblMainData.Location, tblMainData.P1, tblMainData.P2, tblMainData.P3, tblMainData.Status, tblGroupList.PN, tblGroupList.[Group Name] FROM tblGroupList, tblMainData WHERE (((tblMainData.P1) Like "*" & [tblGroupList].[PN] & "*")) OR...

Make the combo box bound to the BOL_Number_to_pull_up_Unique_Number query. In the after update subroutine of Bol_Number put this code: me![Unique Number].requery John M Reynolds

That is possible. When they click a button on the bottom of subform 1, check the data, then do an insert query (and a delete from subform 1's table) to move the data to the table of subform 2. Requery the second subform to be able to see the new data. If you don't want to move records, or if...

It depends on which program you wish to use to play the MP3. I often use a shell command to open up adobe reader to view a pdf. You will need to know the name of the command and what flags, if any should be passed to it. Here are a couple of examples of shell commands I use in VBA...

For speed, Access usually uses inner joins instead of just a Where clause. whether or not this will work depends on where you will be using this. If you are using it VBA, then it would be fairly easy. Perhaps that is like giving directions to someone and saying, "you can't miss it," but bear...