Search results

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...

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...

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...

Please help!!!. I have a query that when I "sum" my auto number diappear. for example, when I run my query I get 22 records, when I suppose to get 2. So, I "sum" or "group by" my column (which I want to do), my auto number disappear. Which I don't want to do.

Hi, Would somebody please help? I’m not a code writer any means. Here’s the issue. I have a form and within that form I have a subform that’s pulling form a query. The form has an auto number. The subform has an Authorization number field that they input according to the auto number that...

Hi all, I have an issue with my query. I'm not sure how to fix this problem. I have a form that gets filled out everytime some needs to expedite parts. everytime we input data, it's giving me double results. Not necessary duplicate, but certain field are dups. and other are not. I can...

Hi, Can someone please help? I have multiple company name in my data that are the same but spelled differently. All I want is to group or roll them up together given one name, or another of my choice. For example… “ADVANCE CO” “ADVANCE FA” “ADVANCED B” “ADVANCED C” “ADVANCED I” “ADVANCED P”...

Somebody help. I have 2 columns, one is OriginCity and the other is DestinationCity. I want to filter out where origincity is like destinationcity. for example. I have origin "Baltimore" however, if I have a destination "Baltimore" I do not want to see it in the results. Is this possible.

Please Help!!! Something as simple, yet the hardest to figure out. Field1 is: "Total Shipment Charge" Field2 is: "FSC" fuel Surcharge Field3 is: "Distance" Field4 is: "ACC" Accessorial however, this field is a formula ( ACC: IIf(IsNull([Allocated Overwidth Charge...

Please help!!! The following formula is what I use to add fields, however; when I refresh my data in excel, I get an undefined "nz". the formula works in access, but I can't seem to get my excel to retrieve the data? what am I doing wrong? ACC: (CInt(nz([Allocated Overwidth Charge...

Calling out to all Access Guru, I'm stuck once again. In my Shipment detail table, I have a field called "Are_the_parts_being_sold?_Yes and "Are_the_parts_being_sold?_No" Format as "Yes/No" respectively. On my form, I ask the question "Are the parts being sold?" then I have a "Yes" and "No" for...

Need help from the experts, On my table I have created a field and called it "US Domestic" and another field called it "Int'l Export". these two fields Data Type (Yes/No). I've created a query and created a form to brings those two fields in. However, if the "Int'l Export" is checked on the...

Is there an Access Doctor in the house? I've been working on this all of yesturday and of no success. I need you guys expertise. I thought that this exercise is simple, but apparently it's not. OK, here it is... I have 6 fields on my form that I want to make required field. i.e...

Anybody knows how to convert dates to week number?

Anybody knows how to convert an # error formula to return "0" Here's my formula: CWT: ([LineHaul]/[Cost/Lbs])/100 #error because it's dividing by 0, but I can't convert it to return zero please help

Please help!!! I've been working on this forms for 3 weeks now and I think I'm going crazy!!! In my Access form I have a field that gives me, Lead_Time, Order_Date and Due_Date. I also have a combo box that listed all my root causes. What I want to do is...when they enter the...

Somebody help!!! I working in form and I want my form to choose from a query on a specific field.