Search results

I believe that when you purchase the Microsoft Office Developer's edition, it comes with the Access runtime and a royalty-free distribution license for the runtime. Check the documentation of the Office/Access developer's edition for more information. Hope this helps,

There are third-party form resizing solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss2.htm FMS has a sizer module at www.fmsinc.com. The Access Developer's...

Try setting the value of fieldB and fieldC from the AfterUpdate event procedure of fieldA. fieldB=fieldA fieldC=fieldA Hope this helps,

You could use an SQL Insert statement to add the values to your second table. currentdb().execute "INSERT INTO MyTable (field1, field2) VALUES (value1, value2)" Hope this helps,

Try setting the control source of the third control to be: =[NumHrs]*[PayRate] Hope this helps,

The 3356 error is telling you that you dont' have exclusive access to the database. If you want to supply a passoword, that's fine, but at some point, you're going to have to address the 3356 error. There's code in the ng_Step2 routine that looks like this: If strFileName =...

The description for error 3356 is "You attempted to open a database that is already opened exclusively by user <name> on machine <machine>. Try again when the database is available." Does this make sense for your situation? Do you have exclusive access to the database? If you need to enter a...

Do you mean if an .mdb file resides on a drive that is mapped to "F:" on your computer, you can't specifiy "F:\MyDb.mdb"?

The MoveSize command might help. There are some examples in our Window Manipulation Examples database: http://www.peterssoftware.com/winmanip.htm Hope this helps,

Check the underlying record source (could be a table or query) for both the Product form and the Order form. Make sure that the new fields you created are in each underlying record source. Hope this helps,

I don't know if there's a way to do that. I recommend that you consider converting the macro to VBA code. Hope this helps,

I would strongly recommend using autonumer primary keys instead of using a function to return the primary key value. This might help you avoid the problem you are having. Hope this helps,

You can link the tables from the external database to your report database, if you wish. Just go to File > Get External Data > Link Tables to link the tables to your database. Then you can treat them like regular tables and create queries and reports from them. Hope this helps,

Is this what you're looking for? DoCmd.OpenForm "MyNewFormName" DoCmd.Close acForm, "MyFormName" Hope this helps,

The checkbox control has an AfterUpdate event procedure that you can use to make text display. For example, if you have an invisible label named "MyLabel" then (from the AfterUpdate event proc): MyLabel.Captiion = "VIP" MyLabel.visible = true Will display the "VIP" text. You'll probably also...

Here's an example from Access help, slightly modified: Dim dbs As Database Set dbs = CurrentDB() dbs.Execute " INSERT INTO Employees " _ & "(FirstName,LastName, Title) VALUES " _ & "('Harry', 'Washington', 'Trainee');" dbs.Close Hope this helps,

There are some third-party form scaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm FMS has a sizer module at www.fmsinc.com. The Access Developer's...

I suggest you start with the Orders.mdb sample database that comes with Access. It may have 90% of what you need. Hope this helps,

Try this: varX = DLookup("GroupToGroupMember.GroupMember_ID","GroupToGroupMember", _ "GroupToGroupMember.Group_ID = CDbl(Me.Group_ID) And GroupToGroupMember.GroupMember_ID = CDbl(Me.GroupMember_ID)") Hope this helps,

You may need to normalize your data. "Normalization" is a term that basically means divide up your single big table into multiple smaller tables so that there is little or no repetition. If you search the Internet for "data normalization" you'll get some good sites to take you in the right...