Search results

Try putting a DoCmd.Maximize in your form's OnActivate event procedure. Hope this helps,

You can modify the value of the top or left property of the control to move it. Hope this helps,

You'll have better luck with responses if you post your questions separately. #1: Open your pay form as a pop-up. #2: Try it out and see if it works. You should be able to specify the name of a control on another form for the control source of a control on a different form...

You need to set a reference to ADO before you can use it. Click Tools > References, and check the box next to ActiveX Data Objects. More info: http://support.microsoft.com/default.aspx?scid=kb;en-us;184233 Hope this helps,

Here are two links that might help: http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc97/html/msdn_command.asp Regards,

When I do this I'll copy the query text into a text file, then add continuation characters and quotes, etc.. Make sure you have a space after the "&" in your continuation... Ex: strSql = "" strSql = strSql & "Select Myfield" & _ strSql = strSql & " From Mytable" Hope this helps,

You may not have a reference to DAO. Click Tools > References from any module in design mode. Do you see a check mark next to "Microsoft DAO 3.x Object Library"? If not, put one there, then recompile. Hope this helps,

What is the text of the error message you receive?

Use the "Nz" (NullToZero) function Ex.: nz(Myfield) Hope this helps,

No, it won't break any rules. You are dealing with two different attributes of different elements. One is your customer's bid dollar amount, and the other is the contract dollar amount (if I understand your situation correctly). Even though they are both dollar amounts they have different...

Have you tried: http://www.mvps.org/access/api/api0001.htm Hope this helps,

DoCmd.RunCommand acCmdAppMaximize Hope this helps,

Our Label Saver freeware may help you. You can specify a number of copies, and a label starting position when you print: http://www.peterssoftware.com/ls.htm Hope this helps,

This might help: rs.FindFirst "[Organization Name] = " & chr(34) & Me![Combo56] & chr(34) ... and, yes, it's always best to use an autonumber field as your primary key field. The problem with quotes in text strings is just one reason. Hope this helps,

Try a DoCmd.RunCommand acCmdSizeToFitForm ...from your form OnActivate event procedure. Hope this helps,

Have you seen the Northwind.mdb example database that comes with Access? It has lots of good examples including an Employees table and form. If you want to delete a record from a continuous form subform, you should be able to select it by clicking the record selector on the left, then by...

Check your disk drive for a file named "db1.mdb". See if your queries, etc... are there. Use the find feature of windows to find files that changed recently. See if there are any .mdb files in that list. One of them may be yours. Hope this helps,

It would strongly suggest that you reconsider what you are doing. Use autonumber for your primary key. If you want some other field that has leading zeroes and starts with 40000 or whatever, then create a field to do that. You can use DMax to find the max number in a column of a table...

It sounds like you will need to run the code from two places - the AfterUpdate event of your field, and the OnCurrent event of the form. The most efficient way to do this is to create a function or sub that contains the "if" statement code and call the function from the AfterUpdate, and...

You can use the function xg_ReplaceAllWith() available in our free Access String Function examples database at http://www.peterssoftware.com/strfn.htm Ex.: '* Remove carriage return and line feed from MyString '* Replace with space. MyString = xg_ReplaceAllWith(MyString, vbCr, " ") MyString =...