Search results

Do you mean... Is this what you are looking for? All you have to do is have all of your assignment statements (in the Set) separated by commas. I hope it's this easy and I'm not missing something. Update TableX Set ColumnA = 1, ColumnB = 2, ColumnC = 3 . ...

Hi all, Thanks in advance for your help with this dilemma. I have a form, which upon the click of a button runs vba code to iterate through a bunch of log files in a directory (FileSysObject), and vaccum the contents into my db. When I run this process from outside of access, using an .exe...

UNC Path? I would think you could just have a link, and the href would be something like: <a href="\\mywebserver\mySharedDirectory$\mymdb.mdb"> I did this from my local machine referencing an .mdb file on a network share, and it worked fine (I had to click "Open from this location")

If you don't have a web site... ...or your web site doesn't get a lot of traffic, and you still want to help, you could probably do a google search and click on the link they have to this site. I don't have my personal site running currently, so I will do this as much as possible in the meantime.

Here are some resources to start from. Something I would suggest, is that as you work your way through this stuff, and you get into programming the applications yourself, just come out to this forum whenever you come across an issue or hangup and you will more than likely be able to resolve it...

My solution... ...do a search for "DateDiff" in this forum. If you are not familiar with this function, it can take two date/time stamps and compute the difference how you want to see it (which in this case is probably hours or minutes). At any rate, you will probably want to then change...

Just a thought Maybe it would work better for you to build your SQL statement on the fly (based upon responses on your form), and then execute the SQL statement (doCmd.RunSQL) based upon an event like a button click. ...again, this is just a thought, but often when I have a form talking to a...

To relate or not to relate, that is the question... Please visit this link: http://www.ecu.edu.au/pa/rswa/workshop/What%20are%20databases.htm:cool:

This one is pretty good... Click Me

why not use vba? In the event that would be updating the database (either Click -- button -- or LostFocus -- most other controls), present the user with a warning message: If vbYes = msgbox ("Are you sure you want to do this?", vbYesNo, "Security Check") then Go ahead and update code...

Most likely... ...this is happening, because the subform has a query or table specified as the control source. I know of one way to get around this off the top of my head: Don't specify a control source in the form properties, thereby unbinding all of the controls in the subform. Then, in...

Not going to do another design... I think, building off of my original design, that I would do the following: 1. Take Rate out of Service table and put it in JobService table 2. Add tables Company, CompanyEquipmentRate, CompanyServiceRate, CompanyMaterialRate, CompanyJob, JobEquipment and...

How about a tabular form? Would displaying the data in a tabular form be of any help? You would be able to display all of the data that you want, but the data would be separated into rows on the form.

Lose Focus! In the field where the number is being entered into, in the LostFocus event, do something like this dim db as Database dim rs as Recordset set DB = CurrentDB set rs = db.OpenRecordset("Select Name from Customer where Number = " & txtNumber.value & ";") txtName.value =...

Let's see here, if I understand correctly, you have a db structure something like this JobService| |Service JobID | |ServiceID ServiceID |---------- |Description Hours | |Rate / Job |/...

Have you tried... ...running the smaller pieces of your subquery separately to see what value is being returned? SELECT B.Field1 FROM Table2 B WHERE (B.Field2 BETWEEN #01/01/2003# AND #25/01/2003#) GROUP BY B.Field1; and SELECT Count(B.Field1) FROM Table2 B WHERE (B.Field2 BETWEEN...

... P.S. I hope I understood your question.

Select Top 3 Policy, Division, Procedure From YourTable Where Policy = YourPolicy and Division = YourDivision Note: This will return the top three based on ordering by the primary key. To get a different result set, try using Order By and the field you want to order on. Cheers!

Thanks Shay! I think that I can do something with the logic you gave me. This should do the trick. I'll let you guys know after I try it tonight.

I want to see the same data for all rows, all at once in a tabular form. Again, the problem is that there isn't an "As You Go" event to process the logic against each new record that is output into the tabular form (that I know of) -- hence I am here.