Search results

FYI, it only created the _be it didn't create the _fe.

Yes, my goal is to have exact same db with one db having _fe and the other _be. all the form should have linked, but it's not. I will look at you link and see if it's done differently.

Should I have a _be and _fe attached to the db?

When I did that, none of my form is listed on my _be (backend) Db.

2003, I never heard of it, somebody recommended that to me but I don't know how to go about it. I have approx. 20 users/planners that's going to be using this db.

Please help, I have access DB that multiple users are going to be using it. I want to create a front end and back end so that muiltple user can use. I have 2 question, 1. is how do I create a front end and back end split. 2. If my db have autonumber, does it matter if I create this db split...

forgot to compress....anyway here you go.

ooops file too big to attach

Please help somebody, I have a combox on my form (main form expedites). Everytime I select the supplier name the address did not populate. I've been working on this all day, and I'm stumped. please help. attached is my db. go to main form expedites, then go to as you are inputing new...

Jdraw, Nevermind, I figured it out. Here what I did. Premium_Cost: IIf([Mode]="Ocean",[OceanCost],IIf([Mode]="Broker",[BrokerCost],IIf([Mode]="Small Package",[AirCost],"No"))) Thanks, you guys are a great help through all of this. I truely appreciate this site.

Calling all experts, Would somebody please help me with a query formula. I have 4 fields, Shipping Mode (which have 3 options, Ocean, Air and Broker). Depending on what they choose, it will calculate appropriately in a separate column. So...my issue is, I want to add another column called...

Yes, my new db may primary keys, however I'm just a beginner in access. This db was written from somebody else. My boss wants me to redesign something like this for our parts division. I'm trying to do my best. I've gotten this far by asking you guys.

You are awesome, thanks a bunch. If you are ever in Atlanta, let me know, I owe you a few beer. Can I ask you one more favor? In my main form, right now it's reading from "shipper" table, I want it to read from "dbo_supplier" table and keep my combo box as is. I'm not good with forms.

Yes, I know. My new DB does not have that many tables. I had to copy my old one and post it. The one I'm working on is clean. In the query I mentioned, scroll all the way to the right "expr1" is the sum that I tried to plug in. If you run the query, notice that there's only two records...

OK, see attached DB. qry planner form is the query.

four of my tables are linked ODBC (external). Let me try to re-do my tables and I will post it when I'm done. thanks so much for you help. I have no more hair left to pull :-)

I'm crying very hard right now. I'm not getting it. I've tried it every way possible. If I do the group by, I will get what I want, but the Auth num is not there. And, yes the tick is check on the Auth Num field.

Not sure if I understand. The way I did it before didn't work.

Sorry, let me upload my excel

OK, It worked but with one little quarks. It's summing everything for both Auth Num. Of course I should of know. I want it to sum if the Auth Num is the same.