Thanks to all the would be responders ;) , but I managed to resolve my problem!
SELECT Inventory.[UPC Code], Inventory.[Item Number], Inventory.Description, Inventory.Model, Inventory.[Serial Number], Inventory.Critical_flag, Inventory.Room, Inventory.Building, Inventory.[Status Code]...
hello all,
i have a problem with a subform retrieving recordsets based on combo box on main form (IMS_frmTR)
My subform (query) consists of these fields:
SELECT Inventory.[UPC Code], Inventory.[Item Number], Inventory.Description, Inventory.Model, Inventory.[Serial Number]...
Many mahalo's for the quick response!
Drexor, your suggestion was right on...I removed the quotes and all worked perfectly. Funny, I thought I tried every possible scenario with the true, false, 1, 2, w/quotes, w/o qoutes?
ToddWW, I even tried your suggestion prior to this post but it seems...
hello all,
hoping someone can assist. the following statement grabs all fields and displays all the data, however i'd like the query to display only "active" records but i'm having difficulty with the "WHERE" clause. The fieldname is "Active" and is y/n type.
this works but retrieves all...
I have a similar problem where I want to update a fields datatype. My field name is "Tech2Notes" and it's datatype is "text", I want to change the datatype to "Memo". I tried modifying the above syntax but kept screwing it up! I would imagine this is simple to do but I'm pretty brain dead...
Hello all,
Hoping someone can assist in my problem. I have 10 Access applications (front/back end) scattered about the Pacific, each app is the same. I have recently modified fields (data type) in the back end tables and want to field the update via automated script that would update the...
Chris,
Being a novice at web design I appreciate most replies, even sarcastic ones like yours, but can you at least elaborate on why I shouldn't use frames?
Thanks,
Kevin
Hello,
I have a web page (index.asp) that consists of 4 frames pages; top_banner.asp, leftFrame.asp, mainFrame.asp, and rightFrame.asp. I want "index.asp" to display a single scroll bar for the entire page, I do not want the individual pages to display their scroll bars.
The following disables...
Golom, thanks for the quick reply. I understand the summing portion of your statement, this will help me alot once I can get the text field converted to number. In your second option:
Select (Val(Left([TextTime], Instr([TextTime],":")-1)) +
Val(Mid ([TextTime]...
aloha all,
need some serious help here ...been stuck on this problem for two days now! here's my problem, i have a populated text field within my access mdb that i need to convert to a number field. the text field displays: 24:30, 6:45 (w/out leading 0's), etc., representing the total hours...
I have a similar problem and hope someone here can help. My table consists of two NUMBER fields that represents HOURS and MINUTES, where users input total hrs worked on a project ...in many cases hours worked are in excess of 23:59 hrs/mins. I would like to sum the two fields into a HH:NN...
PauloRico, thanks for the quick response.
My table design however requires multiple technician fields as there can be as little as one technician or as many as five technicians working a single job. Additionally, for each technician responding to the job there are corresponding...
Aloha and mahalo to all that respond: Here's my dilemma, I'm trying to query multiple fields in a single table to produce the results below.
The following resembles my table (fields are in bold):
jobID tech1 tech2 tech3 tech1remarks tech2remarks tech3remarks
1 joe...
Once again Aloha everyone!
I'm encountering the "...unable to create a MDE database" error msg. so of course I can't convert my mdb into mde. I'm using Access 2k. I tried opening a form and viewing the code in VB to compile since that's what everyone recommends however the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.