I have a report that has a parameter written in VBA. The powers that be would like this parameter listed on the report. This is part of the code.
strBegDate = InputBox("Beginning Date")
strEndDate = InputBox("Ending Date")
I would normally build it in a query but...
I have a main form that has a field called received date, and I need to copy the information to a subform received date as soon as a field has gotten focus.
I can not use parent and child links as the user needs to connect the information in the main form to the records that display in the...
I am rather new to SQL and could use a little help. This is my problem. I have a report that needs to pull up when it reaches the current date.
Meaning that the user enters a date and then in 60 days it pops up in their follow up items when it equals the current date.
This is the SQL stmt...
I have a form with a date field that I am trying to set up so that it only pulls in the current date information OnLoad.
Can someone give me a sample?
Thanks
Hello;
I have been working on a database that the employees sign in to and which will generate a timesheet. My problem is getting all 14 days on one sheet. Each day has multiple punchs. Management wants to see all punches.
I figured in order to get all days on the sheet that I was going to...
I use this code with a view and it works but when I change it to a stored procedure it does not work. I assume that a stored procedure has be handled different. Can anyone help me.
Const stmt = "Select * from vwDeferred_rpt where Client_ID like '[Client_ID]' "
Dim varClient As...
I am really new to SQL. I have two colums that I am doing a summary on then adding the two sums together to come up with a balance. Problem, if one sum is blank it does not add across to the balance.
How do I do this?
I have listed below an sample I have been playing with...
I had a form that needed a few command buttons but did not like to looks of all of those buttons.
So what I did was to use a label, and then put an event procedure on the on_click.
This way I can format the label the way I wanted, and it still functioned as a command button.
Thought that...
Maybe someone can help?
I have been trying to find a list of keycodes, and have not been able to do so.
I want to disable some items, but need the keycodes to do so.
I know that page up and down, is 33 and 34.
Can someone point me to the right direction.
Thanks
Hello;
I have a field in a report that is coming across as seconds how can I show this as so many hours and then minutes.
I have never done this before.
Can anyone help me?
I have a csv file that I am importing and it has a field that I must calculate the amount of minutes, and seconds on. The field in the csv file is set up as 00:00:00.
I am importing the field as:
.Fields("Call_Duration") = IIf(Len(Tokens(1)) = 0, "00:00:00", Tokens(1))...
I dont know if anyone can help, but thought I would give it a try.
I have a form that I use the Microsoft Date and Time Picker Active X control. When I set the control source where the date needs to be held I get this error:
Cant set null value when checkbox property = false.
Everything I am...
I am not sure how to start this so maybe someone can give me some help. This is what I would like to do.
I have a combo box that when a specific item is picked that a text box pops up, and the user then needs to input the item name. Otherwise the text box is invisible.
Can any one help...
I have a Active X calendar control which when a date is pick saves to a field in the table.
My question is, the calendar is visible all the time, how can make it visible only when needed for that field?
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.