Search results

I'm trying to order a query by a field calucated by a subquery but I keep on getting an error. It's got me stumped and I can't figure out what it is. Edit: Please excuse my markup, I kind of tried learning VBA/Access overnight and just went as I learned. SELECT tblOfferItemInventory.ID AS...

Good afternoon, I have run into a brickwall with section of my DB. I am wanting my code to open a query of "tasks" it needs to run. I've always used the current time as a criteria where each record in the table has a "start time" and "end time" window for running the task. I want to start...

I recently added a function to my DB that calculates road miles between two zipcodes using the Google Maps API. That part is working great however I wanted to cache the results in a table so the code doesn't have to go out into the internet every time. Every time the SQL insert statement...

I've looked over the code 100 times and I can't seem to get it right. Does anyone see anything wrong? DoCmd.RunSQL INSERT INTO tblGeneralItems (ItemCode, ItemDesc, Species, SubSpecies, Note) VALUES (04211, 'Chicken Trim', 4, 211, 'Added By Sys');

Good evening, Does anyone see anything wrong with the santax below? I keep on getting an SQL santax error and I've tried everything. Private Sub Command2_Click() Dim CurrentUser As String Dim UserIntl As String CurrentUser = fOSUserName() UserIntl = DLookup("[Initials]", "Users"...

I have a table made up of and orders table, a statuses table and a link OrderStatus table. The OrderStatus table is made up of 3 fields. ID, OrderID and StatusID I have 6 different statuses that are each order is updated to once after the other in a consecutive order. I need a way to build a...

I have a database with items that I want to quote to customers. I have a items table, a quotation table, and a quoted items table that contains the ID's of both tables creating a many to many relationship. My question is I have a split form that is bound to the items table. This form lists all...

I have a text field that I would like to make a hyperlink to search google using the Company + City + State of the current record. Google's search code is http://www.google.com/search?q=SEARCHWORD I've tried using a text field and setting the value of the field to code below but every time the...

I have a database that I want to use to keep track of freight rates that truckers give me. I have a table called rate requests where I input my requests for a price. I have 4 fields which are pickup city, pickup state, drop off city and drop off state. Both pickup city & drop off city are combos...