Search results

Hey All, I am in need of a Date Repeater in which the user can select a Start Date and an End Date as well as any of the weekdays (denoted by checkboxes). These dates will then be used to insert entries within one of the tables via SQL. Does anyone have any examples of such a function or...

Hello, First, I'm using Access 07. I am opening up a form with a filter. I also have Navigation Buttons enabled on this form so the user has the ability to go through each of those records that are filtered out of the set. The problem is that with the Navigation Buttons toolbar comes the...

I am trying to insert into a table using the SQL INSERT INTO statement. The table I am trying to insert into is called t_comments. That table has 8 columns. This code works for 1 record: INSERT INTO t_comments VALUES (1,2,3,4,5,6,7,8); But, if I attempt to enter into multiple records: INSERT...

I have been trouble with a function that i coded to requery a subform and keeping the same record position. My function is as follows: Public Function Search_AND_Requery(search As String, frm As subform, nPK As Integer) frm.Requery With frm.Form.RecordsetClone .FindFirst...

How can I select the record of a subform, using its PK, if that subform is continuous? I've searched the forums for quite awhile and seen the usage of bookmarks, and also read that bookmarks become invalid when records start getting deleted and that would propose a problem. Any aide would be...

Hello, I would like to determine the key pressed without using the actual event on a form. When looking at the event I can see they have created an integer that stores the ASCII value, so my question is how do I store the key pressed into an integer of my own making without the event? Thanks!

Hello, I need some help with a piece of code for a db. This code checks to see if the last three characters on a ControlSource.Tag property are "Req" and if they are, tests if it's null or = 0 and if it is then it outputs a msg box stating that the control.ControlSource is required. It does it...

Hello. I'm trying to build a query criteria for a tab control with three different tabs. They are all using the same subform in each page. I want to be able to set the criteria for one specific field to the current tab control page that is selected. Does anyone know how to do this? I wasn't...

Hello. I have been struggling with this problem for quite some time, and it's getting quite frustrating. My knowledge of access is limited and i have been using this forum to educate me in the best of ways possible! But, now i have a question that i really need help on when it comes to the...

hello. i saw this post http://www.access-programmers.co.uk/forums/showthread.php?t=116737 , and i was so happy because i thought it was going to be my same problem, but alas! similar, but different. i want to know how to do a 'not' query on every value in table's field. the query should list...

hello. out of curiousity, i would like to know when is the time to use SQL server as the be for a database? examples or, guidelines. thank you!

Hello. As my title states, that is my problem! I'm building search criteria from a form and have multiple list boxes... I want to be able to determine whether or not a list box has items selected or not. I have tried as many things as i knew how to with no luck... Also, i searched the forum...

Hello. So I have a main form that has a subform located onto it in datasheet view. The subform has all editing attributes locked. I want a button on the main form that when pressed, unlocks the subform and then deletes the record selected. On my button I know how to change the attribute of the...

Hi. I was just wondering if you can hide a form in the windows status bar?

So, I hope that i'm just making a simple error, because as far as I know this should work! I have two tables. (and i'll just simplify it because the other info isn't necessary to aide me!) tblProduction ProductionID - Autonumber - PK ProductionLocation tblStorage StorageID - Autonumber - PK...

Okay. So, i have this frmProduction that has a cbo box on it, and when i select the value 'sold from field' i want it to open up another form (frmSales) that i have already created. Now, not only do i want it to open it but i want to have some information on frmSales filled out with the values...

Hello. Just wondering if there was a way to detect the current year? (2006, obviously). Reason being, have an input date of year a block of trees was planted and i want to have an automatic calculation for the 'age of trees'. Thanks!

Hello. So, I have a logon form with a combo box for user name and a text box for the password. When they hit login, the user is then looked up and the password verified and if it's good they're taken to a specific screen that gives them specific options. What i want to know is how to hold the...

Okay. So, this is my set up. I have a form that has various input fields that are connected to my main table. What I want to do is have my form allow the user to enter information, leaving some of it blank if they don't want it, and then press a button and it will open the query with the...

Hello. So, basically I have an input form. I disabled pretty much all of the controls and instead of using the left and right arrow buttons I wanted to create my own ones to go to the next record. What happens is that the button pushes down, but doesn't unpush. And then if i push it again it...