Search results for query: *

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

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?

I am new to SQL. I have a field that I want to force atleast a 5 digit number to be input. I set it up as a null field now they are entering 0 to bypass. Anyone have an idea of what I can do?

I am really new to SQL. I have built a DB with Access project front end and SQL and a backend. All stored procedures work when logged in as SA. But when I sign in as a user I get a "cant not find record source sp_XXXXXXX. I did go into securities under SQL Database Access. I did...

I am rather new to SQL and I am having a problem with a date calculation. This is the formula that I am using: GETDATE () - Received_Date as AGE What I am looking for is the number of days between the two. I know that GETDATE uses the system date, and the system date is correct but in...

I have been working with the FAQ on this but still having problems. First combo (category) feeds second combo (subcategory) This is the SQL that I am putting in the row source in the properties form. I keep getting nothing in the second box. What I have written is below: SELECT...

I have a combo box that has two columns, when the user picks from the combo box I would like the second column to fill into another text box. Meaning combo box: Employer Name (Column 1) Employer No (Column 2) Text box = Employer No Is this possible? If so please your help would be appreciated.

I have read many threads on this topic but still having problems. Most depend on a query, I can not use a query. What I am working with is an adp(project)versus mdb. When the user picks from Category, then it will show items needed in Sub-Category, then what is picked will show the items in...

Help: I am really a novice working with SQL. I have an Access 2000 Project form that has three combo boxes, and the information needs to be held in the prospect fields in the table, as I report heavily off this information. The combo boxes need to cascade from Combo Box 1 to Combo Box 2 then...