Search results

Seems to me that the only thing that changes is the availability of the product you are selecting. If that is the case then create a query, bind your form to that query and every time you check the boxes the record will be updated. If you want to have a bit more difficult, which is where I...

I believe that fixed it. I have been using that name for the field for a while and had not come across any problems before so I never thought of that. Thanks for the time

I have set a breakpoint in the function, that is how I found that my value of "5.25" is being passed to the function as "20520". I have used the Screen.ActiveControl as suggested by RuralGuy and it show that the control where I am using the function is the one passing the value (that is...

Exactly, have the database open automatically just as Darth Vodka suggests and then on the startup form place code that executes on open and that'll do the trick.

If all you need is find ways to read/write to a table then search the forum for editing recordsets programmatically. There are plenty of examples you can use and modify to your heart's content.

Well, by system I meant the pc that is running the database. If your db resides in a server then you don't even need to worry about shutting down/turning on the system, but I get from your post that that is not the case. You would have to do your homework on finding ways to turn the pc on...

I am not sure this can be done while access is not running. One thing I would try is looking at other automated solutions outside access. Another way would be having the system turn on automatically and run the database on start. Once your first form opens you can run your code from the "on...

Hello All, I have two bound text boxes that are using the same function to convert their decimal source data into fractions. The function works well on one of the boxes but generates an error on the second box and that is because the number "20520" is being passed as the parameter (the function...

Not sure I'm following you on what exactly you want to accomplish as seems to me you are not calling things the proper name (I don't think we have cells in access). However, many calculations can be done in the underlaying query for the subforms instead of creating modules for them.

How the combo box "stores the data" to the table depends on how you are saving your record: if the form is bound then after creating the appropriate field in the table assign that field as the control source for the combo box. If unbound, you will have to modify the code that saves the record to...

I'm a bit confused when you say that the subform is "connected to a different table" but the "subform is unbound." How are records related to each other and what is the function of the subform? What works best for me is to have all forms unbound and then write code to save records to whatever...

hewstone999, searching yields several hits check this one out: http://www.access-programmers.co.uk/forums/showthread.php?t=138021 if it is not what you're looking for hit search, type "word", "export"

Thanks Bob and gemma, I solved it with a combination of mask and code. Changed the mask to "00&0000;1;_" forcing the user to type a decimal point in the specified position and then test with code similar to gemma's. Thanks, George

Create a form with the fields you want displayed and make its default view datasheet (my personal preference). Create a query that is going to serve as the record source for this table. In your main form add the subform control and set as its source object the form you created earlier. Now write...

sgtblitz, If I read this correctly, in your form you must have text boxes for each search criteria: Product name, ISBN, and author. Dim your variables strProductname, strISBN, strAuthor as strings and then set your variables = to the corresponding text boxes in your form eg strProductname =...

Hi All, This might be easy but I can't seem to get it working. I want to force users to use decimal point in a field where units of measure are entered eg. 12.5647, 9.5478, etc My input mask for that field is 00\.0000;1;_ but it does not save the decimal point. 12.5647 will be written as 125647...

Thanks aprpillai, but I have tried that already and it does not work. Any other ideas?

jdraw, thanks for the reply. Every 'projno' can have several distict 'ticket' numbers. With every 'projno' there could be several distinct 'onum'. Both 'onum' and 'ticket' are not related but can be tied up by using the 'projno'. When I join all tables and run the query I get both 'onum'...

Hi All, This might have been answer on another occasion but I can't seem to find anything that looks similar. The following SQL SELECT EDGW_HOLD.RunDate, CCOEORDE_RIZZO.PROJNO, CCOEORDE_RIZZO.ONUM, CCOEORDE_RIZZO.FPNUM, EDGW_HOLD.Ticket, EDGW_HOLD.Defect, EDGW_HOLD.Footage FROM...

I am using a query. The form is a bound form. I have tried refresh but still no update. What I don't understand is the fact that it works with non-null records. Also, I have 2 text boxes in the form that get their data from the same query and those get their data only when the field in question...