Search results

Hi Everyone, So I can't seem to figure out what or how to do this one. I have a table that has the following fields Asset_ID, purchase_price, date_ purchased, life_cycle, and salvage. What I need to be able to do is somehow track and be able to see the current value of an asset. So for example...

Hi Everyone, I have 1 last report to finish this database that I have been working on and can't seem to get my head around how to do this. I have a table tbl_transcripts that has 6 fields in it. [student], [subject], [class],[date_comp], [credit] and [comp] and "comp" is a yes/no field. I need...

Hi Guys, I have an IIF statement in one of my reports. The statement works great has long as there is data in the field [Text48]. If that field is blank then I get the #Error. I have tried several NZ or Is Null statements in it but all I get is that the statement is to complex then. What I need...

I have a form frm_austin_logs that is bound to a table tbl_logs on the form I have 8 fields that are not bound to the table that I want to pull there information from a query. I created the query qry_austin_log_gpa and if I run the query stand alone it works fine. In the form I put the following...

Hey All, I came across the sample database that Smig made and am having problems getting it to work. Modules are not my strong point for sure. He says You will need to set up some eMail details for this to work (they are all in the mdl_PublicDeclerations) This is were I get lost I can't seem...

Hi All, I have a problem that I can't seem to tget my head around. I have a table with a field called strMoYr with the values like "December 2008" I am running a query that I need a way to only count the last 12 months. Example would be if I run the query in January 2009 I only need it to look...

Hi All, I hope someone can help me figure this one out. I have a Form frm_inventory which is based on a query which is based on a single table. On the form I have a field Text86 which is unbound that shows me the totals(sum) of a number field in another table. All of this works great, my problem...

Hi all, I know this is more then likely a simple thing but I cant seem to figure this last little part out. I have a Form that has 2 combo boxes on it. cbo2 is populated from criteria of cbo1. All of it works fine. I have it set up that when the user opens the form the combos are blank and my...

Hi All, I have a query that I just can't seem to get my head around. The end result is that I need the query to return ONLY records where the TOTAL_ON ( total on hand ) is equal to or less then the MINIMUM. part of the problem is that the MINIMUM field is a text so I have a field Min that...

Hi All, I am trying to get code for a button to work. I keep getting errors everytime. I get error 1334 if I do seperate DoCmd lines. If I try both on 1 line I get 2943 errors. Im still pretty wet behind the ears on VB code so any help would be greatly appreciated. I have tried like this...

Hi All, I have a project that I need help with. I'm trying to recreate a form from a Borland dB3 database. I was able to find code from the Northwind database to do the toggle buttons on a form. I can get it to work fine as long as its a single form and only displaying 1 record at a time. What I...

Hi All, I have a project that I need help with. I'm trying to recreate a form from a Borland dB3 database. I was able to find code from the Northwind database to do the toggle buttons on a form. I can get it to work fine as long as its a single form and only displaying 1 record at a time. What...

Hi All, I found a DB that RuralGuy had posted on another thread that is exactly what I was looking for. The problem that I am having is I had to add a subform that shows comments for the classes that are scheduled. It works correctly on opening the form but I can't seem to get an code to work...

Hi All, I search the forum but could not locate exactly what I was looking for. I have a Form that is a has 31 fields that I need to color code beyond the 3 that are there. I have seen code that people have tried but everytime I try 1 of them It colors all the fields. I need to it to color 5...

Hi All, Im not sure if this can be done or not. I have a form that when a part is received gets entered there and a quanity with a check box for if labels are needed. When the button it clicked I need to generate the labels bases on the qty that was inputed on the form. Example: part_num...

Hi All, I have an inventory DB that I am trying to setup. I have 2 table "tbl_parts" which holds my barcode_num, description, stock_level ( qty on hand ) etc. The second table is "tbl_stock_level" which has barcode_num, trans_date, qty, emp_int. I have a form frm_parts_used that when the user...

Hi All, I have a form that I have a textbox that is a calculated field. I also have a label that is set to not visable. What I am trying to do is if the textbox ( Text92 ) has a value of <=-1 the make label visable ( Label27 ) I have tried the following and none of them seem to work it...

Hi All, I think I have tried almost every IIF count that I can find on here and I am getting errors on them. What I have is a Form that I have a text box that gets populated by a popup calendar ( txtDate1 ) which is working fine. I have another text box ( txtcnt1 ) that I need to get a value (...

Hi All, I have a question that I can't seem to get my head around. I have a form that has 10 text boxes ( txtDate1 to txtDate10 ) which get populated by a datepicker. I need a way to count how many of the text boxes have a value in them. I have tried Dcounts and Nz Nulls but cant seem to figure...

Hi All, I am stuck, and can't get my head around an easy way to do this. I have a table that has an Team_mem,strmonth, and 31 other fields 01 through 31 with valves of D, V, A etc and I need a way to count how many times the letter V shows up in fields 01 through 31 in a given row. Example...