rwalle
Last Activity: Jul 2 '19, 12:40 PM
Joined: Jan 11 '10
Location: Monterrey, Mexico
-
If I got it right you have a employee table where you have all the employee related data in fields like Name LastName Address,StartDa te,Dept. and you need to update one or more fields like position or salary rate ,as if someone will be promoted lets say from front desk to sales? is this what you want to do ? -
Event Log Table
I have a DB where I'm tracking mainteniance work orders, It works fine so far, now I want to add a table to store data about who and when is modifying a work order, the idea is once user clicks on a form save button a new row is added to the event log table with the WorkOrderId; userId( coming for a hidden form) and date/time so I can later track who did what,
any help will be much appreciated
Raymundo Walle -
here is a example DB I have MS Acc 2007 it has a report that has fields where the 0 is swaped by a "" and also using conditional formating I have changed the field back color and using a check box in the form that calls the report VBA Code switch visible property of several fields...Leave a comment:
-
I usually do it through VBA code in OnOpen Event for the Report something like
Code:Private Sub Report_Open(Cancel as Integer) Dim VisEnable If Me.Field<1 Then VisEnable=False Else VisEnable=True End If Me.FieldName.Visble=VisEnable End Sub
Leave a comment:
-
Back End DB security doubt
HI:
I have designed an MSAccess 2010 DB to handle Mainteniance Work Orders , it has tables like WorkOrder, employees, equipment,depar tment to load mainteniance help request,there are like "customers" who ask for help and "suppliers" ( mainteniance personel that supply the help) , using VBA the app checks the ENVIRON("UserNa me")and based on this UserName and through VBA ,forms and fields are enable/ disable,... -
"WHERE" usage doubt
I have a "MainForm" containing a "SubForm", the SubForm is based on a Query and the MainForm has unbound comboboxes and TextBoxes to built filters that I apply to Subform using buttons in MainForm, it works fine, now I'd like to do this same filtering action but using the query criteria , I have done pointing the query design gird criteria fields to the MainForm combos and Text Boxes, it also works , but I'd like to know how to... -
debug Access Vba Code
HI :
I'm working in an Access DB development, it was fine until I think I did something worng in VBA code, the thing now is I can't open the DB VBA code to try to fix it , once I try to open VBA from the design view of one of the forms or reports I have a message saying " Microsoft Access has stopped working " and this message box has no options but to close the program . .
is there a way to open VBA in a... -
Thanks for the Answers ,
I think it is related with the date format what I did is before put dates in filters I formated them using
also did the same for the Field [Al_Start_Time] so both the field to search and the search box date are in the same formatCode:Format([AlmDate],"mm/dd/yyyy")
ThanksLeave a comment:
-
Form Filter doesn't work for all data
Hi
I have a strange problem in a form filter my set up is as follows
there is a form named "InAlarmResumeF orm" that has a subform "AlmActiveQrySf orm" the form has Textboxes with datapicker enabled "StartDate" and "EndDate" for the user to pick dates to apply to the subform filter.
the way this works is , if the user pick a date in the "StartDate" TextBox and left empty the "EndDate",... -
The code I wrote Build a string Variable named [ManNum], it ends as ([PrdPartNum]like*(Any Text to search)*)
where "any text to search" is text you write down inside "ManNumSrcB ox"
then set the Form_ProdQryFor m.filter = [ManNum] and then set the Form_ProdQryFor m.FilterOn= true
this wayLeave a comment:
-
You can learn how to make a more flexible form filtering in this Neopa's Articlehttp://bytes.com/topic/access/answer...subform-filter
and also here is the code ( based on this article) I have used to filter products based on Manufacturer Part Number or part of this number...Code:rivate Sub ManNumSrcBtn_Click() ManNum = "([PrdPartNum]like'*" _ & Me!ManNumSrcBox & "*')" Form_ProdQryForm.FilterLeave a comment:
-
Mihail, Stewart:
thanks for your response the form is doing what it's intended to
Thanks
Raymundo WalleLeave a comment:
-
Evaluate Null values
HI
I have some problems to evaluate null values,[EmpName] is a string form field that display employee names if an employee is in the table where form is based it works fine for employees that are in the table but when a null val is displayed on this field the If statement doesn't work am I missing something or is there a diferent way to evaluate empty string field values ??
Tks for your help
Raymundo Walle
...Code:If
-
In Xp Mode you choose the VM network adapterm from a Dropdown box,but I cant see the physical Net adapters no Wired nor Wireless Net adapter,I have attached a PIC of the way it should be , in the PC failing the red box enclosed options are missing and I dont know why , please any help will be much apreciates
R Walle...Leave a comment:
-
How to see physical adapter in XP Mode Network configuration for VM?
I have installed a XPMode virtual machine on my Win7 profesional 32B system the thing is that under the Networking dropdown box inside VM settings I can't see the physical network adapter and I need to access it from my Virtual Machine, is any setting I have missed , somebody knows how to fix it
Thanks in advance for your help -
How to change currency format for access installation from Euro to US
I have received a new Windows 7 Profesional 32 bit PC with Access 2010 installed, I discoverd that the currency data type is Euro and it has the "." instead of the "," for thousands amounts,the Access help says you need to correct the PC regional settings, but I went to regional setting page an it stated the region to United States so its correct, but any way I have the Euro symbol in currency fields and the "," and... -
I would suggest a totalized query for each year , then combine both into another query so now you have 2 rows one for each year, and 12 columns one for each month and you are done, use years as the Y axis and time ( month grouped) as X axisLeave a comment:
-
If You´d like to have this Form / subform set up for a search propouse, you could create a query where you will display all the data for the table "Products" that are Code,UPC, Item Description,Pac k and Size
then create a form "SearchSubF orm" based on this query, set the default view as datasheet, create another Form the "Search Form" set up a textBox "SearchText " and a Button "SearchBtn"...Leave a comment:
-
Hi Stewart:
I have set the "descriptio n" field height to can grow and it work but now I'd like to know how to make the others fields height also grow depending on the "descriptio n" field height, this because I have set the border style for all the fields to solid so the report shows as a gird but now some "descriptio ns" have grown and the correspondig "Qty"; and "ProdId" field didn't...Leave a comment:
-
Variable field heigh in Reports
HI:
I have several reports where I display product data, it works fine, but I'm wondering if the fields height can be set dinamically because I have descriptions that fit fine into the 112 char lenght line, but in some prod I have about 150-180 Characters and will be better if I could make in this cases the field height bigger,is there a way to handle this ?
Thanks in advance for any help
Access 2007
No activity results to display
Leave a comment: