Search results

Hi guys, I'm building a database that manages licenses for a software that we sell. I have a small problem and I can't find the proper keywords to finds a solution in the forums. Here's what I have: A table with demographic info as well as a 2 date fiels (Date_Activ and Date_Renew)...

Hi guys, I have a problem which might be eay to fix but I can't figure out how to do it. I've searched google and the forums but can't find the exact wording. I have a main table which holds different companies and their demographic information. Periodically, these companies will send me...

Hi, I created a nice fancy report for my team, I have a button on a form that exports it to a file. Right now when I click it it gives me the default option box allowing me to choose what type of document I want to export (HTML, EXCEL, text, snp, etc.) How do I set this to be Snapshot...

Hi again everyone, From my point of view this should work... it doesn't. I have 2 date fields on a form (StartDate_rForm & CompDate_rForm). I simply want to return a value in a text box if the diffrence between the 2 dates is less than 2 days or more. Here's my code: Private Sub...

Hi everyone, I know that this has been discussed at large in the past and I have found great info in the past threads but none that answered my dilema. I have a query, the criteria is pulled from a form's combo box. Here's my code Field : Treatment Time...

Hi everyone, I'm having speed issues with my database. It's a small DB with about 20 users nationwide. The server is located in Toronto and users from Toronto, Montreal and Vancouver use it. The problem is that it's a big server and there's alot of network traffic which makes running queries...

Hi everyone, I'm having problems with a chart I'm creating. I have 2 queries, 1 SQL multi-table query and another that runs from the multi-table query results. The second has form filters based on drop boxes, the allow the user to chose what they want to see in the chart. Both...

Hi again, I used to have seperate forms, each would have a basic search function that would allow the user to find a record. We have now decided to include all of the forms on a single form using tabs and subforms. The problem that I now face is that whenever I do a search on one of the...

Hi, I have a form and a subform Very simple thing I'm trying to do but my code doesn't work, would someone correct it please. I just want to copy the data that's in a text box on my subform to a text box on my main form. here's my code : Forms![frmMenu]!txtQuestion.value =...

Hi, this is probably super simple (I realy hope it is!!) but I can't figure it and can't find the proper wording to find it in google or the forums. Basically I have a form, on it a bound text box that allows the user to type in the customer's account number. There is also another unbound...

Hi, I thought this would be a very simple matter but I keep searching to no avail. I did find one post that where the person was looking for the exact same thing as me but there were no answers :(. Basically I have a table recording questions that we get. When we log them a time is written in...

Hi again everyone, Here is what I have and where I am stuck. I have an Access DB and an Excel spreadsheet. The Excel spreadsheet is built to gather information from a website that contains statistics we use in the office. There is a "front" worksheet that has basic controls such as dates...

Hello again, Sorry about what is probably a very basic question, I search the web and the forums but could not find the proper keywords to get the answer I want. What I need seems very simple to me. I have several forms which are variations of the original. I need for the user to chose...

Hopefully this won't be as complex as I imagine it! I tried searching but am not sure what keywords to use properly so if this was addressed before, I appologise. Here's my problem: I have a table with multiple fields in it. Amongst the fields I have Agent_Name, Call_Date, talk_time...

Hello everyone, Now I have searched this and other forums for days but cannot get my Dlookup function to work. Here's what I'm trying to do: I have 3 tables, one called Staff_List, another called Question_Form and a third called Questions. The first contains information about our...