Search results

Jon.. Is there a way to do an append query to a different network. Similar to this: SQL = "Insert into TableName IN 'HomeNetInOregon\D:\AA\New.mdb' Select * from TableName" The part I am curious about is the HomeNetInOregon piece. Is there some sort of connection string or something that I...

Insert another text box to the right of your existing one and fill this with the other values. Better yet, just use a continuous form and format the controls however you want. Rich.. I'm surprised you didn't suggest this given your history for contempt towards inefficiency.

One Solution (although it would require some duplication): Drop a child table off of Tbl_Options... call it Tbl_OptionsSub. This will be a One to Many (Options to Options Sub). For each Record in Tbl_Options you can now drop down many OptionSub(s) that match (exactly) records that are already...

Check your recordsource behind the report and make sure there is actually data in there. This error will occur in VBA if you are using a Recordset Object and try to .movelast or .movefirst while there are no recordsets in the Recordset.

What does you table structure look like? If you build the tables correctly you should be able to do whatever you want... Sums, Averages, Outliers, Max/Min, the whole bit. Graphs would be good to use also. You're going to have to be more specific.. Do you have a month table? Surveyee Table...

Check out the WEEKDAY Function and the Month Function Taken Directly From MSAccess Help.. Month(date): Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year. Weekday(date, [firstdayofweek]): Returns a Variant (Integer) containing...

In the sample that was posted... Before you set WordApp = Nothing, try inserting WordApp.PrintOut Search Help Files for PrintOut Parameters

No, you can't make an array of controls on a form. But.. Here's the thing, if you've got enough time, know how, and creativity, you can do anything you want. For instance. If you want to limit which text boxes are shown on a form, you could develop a set of rules that you use when naming your...

Good point

Always the skeptic Rich... I do this against my best judgement, but here you go. Samples Scroll to Microsoft Access Rich.. I yield to your authority. Say the word and I'll delete this post.

What does you current table structure look like? Have you made any tables that are related to eachother. For instance... If you have a School Database One School has many Teachers. One Teacher has many Students. One Student has many Exams. One Exam has many Questions. One Question has many...

Bypass the properties check.. If Not IsNull(Me.txtBox) Then BLAH BLAH BLAH End If Naming a group seems to be a normalization issue. If your tables are normalized, then your data will automatically be grouped by its parent table.

Fogive me Auto.. Would you like me to post a link to some Open Source DBs as pennance for my sin??? :D

Place the images in the same network folder as your .mdb To get the network path, use this.. Dim loc As String, str As String, imgDir As String loc = Application.CurrentProject.Path 'retrieve project path str = "\picDirectory" 'get your image directory imgDir = loc + str Now you've got a...

Here's my take, If you're going pirate someone else's work, at least go find it yourself. I mean, we are talking about the internet here for crying out loud. If you can't find a .mdb file on the entire internet w/o posting to a forum, then how in the world did you meet the minimum req to take...

Just wanted to make this the first ever 3-Oregonian post!! :D

I have to go w/ BukHix on this one. Learning to write functions instead of Event Procedures will save a lot of time and is much more efficient.

No problem.. Did you get the fields of tblJob figured out. You will want to take the majority of your fields from your original table (tblDept) and put them into tblJob. This will allow you to have a Normalized structure as opposed to the <i>flat</i> structure you originally had. Also, you need...

Hey Rick, I cleaned it up just a tad for you. I hope you don't mind. Check out the new table structure. Notice now, that there are 1 to Many Relationships set up. This is called Normalization. There is definitely more to be done, but this is a good start. Pay close attention to tblJob. You...

In your VBA Code Window.. Click on Tools->Reference Make sure the DAO 3.6 Library is checked. From now on you will have to Dim your DAO objects like this.. Dim rst As DAO.Recordset, qdf As DAO.Querdef --- or -- I think you can probably just uncheck Active Data Objects Library from the...