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

Wow, that is genius! Thank you so much this worked perfectly.

I can't do so because the field is actually a string. I was able to get it done by creating the query using an SQL string and using Weekday(Date) LIKE RunOnDays Not very clean but it got the job done until I can find a better way. Thanks for your response though!

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 appreciate the help guys. I'm still getting the error. Here is the entire sub. Private Sub btnSaveOffering_Click() Dim ItemDupCheck As Integer Dim CustItemDupCheck As Integer Dim LCustID As Integer Dim LItemID As Integer Dim ComID As Integer Dim ComTID As Integer Dim CommDesc As String Dim...

Here are the field types: ItemCode Number ItemDesc Text Species Number SubSpeices Number Note Memo

Sorry about that. The quotes are in the code. I just didnt copy and paste them. Here is the code exactly as it is in the VBA editor. 'Check if item already exists in our system ItemDupCheck = DCount("[ItemID]", "[tblGeneralItems]" _ , "[Species] = " & ComID & " And " & "[SubSpecies] = " &...

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

Is there any way to have a button run this code? Or have it simply display "Click here"

Forget it I got it work. You are the man. Thank you very much.

You are the man. Code comes out perfectly but nothing happens when I click it. I have to copy and paste.

Great! Thank you very much it worked perfectly. I'm trying to include the city and state in the search also so I was using the code below. However since the state is a lookup from the states table it is showing the state's ID in the search instead of the name of the state. Any workaround with...

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