Search results

I have a database I have the tables linked to SQL Server 2008. As going through my form updating the VBA errors I have two I can not figure out. The Index and Seek (highlighted in green) highligh it's self in yellow in the module. The primary key is set on ID_D. Have any ideas? Private...

Your awesome! Worked like a charm!!!

I am building the procedure on the Access side. Even if I build it on the SQL side, it should work when I run the report drawing on the procedure for the information through Access. Should be no different than the StartDate and EndDate popups. Maybe I need to Delcare it, but not sure how.

I am trying to create a stored procedure that will allow me to search column named "AuditResults". As the StartDate and EndDate popsup to enter my date range, I would like the keyword search to popup as well so I can enter the keyword I am looking for in the "AuditResults" column. This is what I...

I want to in my Access FE using a stored Procedure to select a date range like I use to do using the Between clause in a Query. For example: a popup screen would ak me start date and end date and I would end the date range I want. I hope that helps. This is what I have so far: SELECT...

I need to set date parameters within Stored Procedures using a sql 2008 R2, with an access 2007 front end. The procedure needs to allow me to set parameters for a start date and an end date.

I want to populate two text fields from a combobox with a command button to enter into text boxes in my form. The combobox is getting it's info from tblcommitteeinfoentry. The two fields are PI and RDOfficeStudyNo. The form name is Frmconsenterror and to populate the table called...

I like the idea of using the windows login and use a table to give the type of permissions each user would have. My question is, is there a sample databse or a script that also describes how to set it up. All great ideas but this is what I would like to do. Thanks!!! P.S. Is there a script...

I have a few questions. I can not get this working at all. You wrote: The new field would be something like DefaultForm and would hold the name of the form which that person loads. Would this be a command button to my switchboard on the login form? You wrote: If the combobox is then...

I don't quite understand the last code to where I put it and what the third field is in the username/password table and what I put in that field.

Tonez90, I agree but I need to be able to build the vba coding, form and table to give the user the ability to login set by permissions granted.

Thanks everyone but I created a login by using this website: http://www.about-access-databases.com/dialog-box-form.html What I need to do is if I can is use this login (if not I'll create another one) and with the windows login create the read only, edit, admin (full access) so I can control...

I need to create a multi-user with user levels such as admin, and read only access database I created. I curently made a login with a password to get in the database but I want to only allow certain people to just have read-only access. I may have to discard the login I created that I found on...

Thanks. Your new shorter code worked well.

I used this to get what I want. >"2010 - Qtr 4" in the criteria section.

I played around with the script and this is what I cam up with but I only need to show the last 4 quarters. This does show 2011 - Qtr 1 Qtr: Format(DateAdd("m",0,[Dateofaudit]),"yyyy"" - Qtr ""q",0,0)

I tried to use your new script... Dateinrecord>datadd("y",-1,[datetoauditto]) but I could not get it to work. It doesn't recognize "Dateinrecord" in the query. Also, I can't get the labels as you suggest to show properly. "2011 - 1 Qtr"

Now I am trying to show just the last four quarters. With the script I have now I am showing five quarters in the graph. I only need to show the last four quarters or calendar year. How would I change this script to what I need to show? Qtr: DatePart("q",DateAdd("m",3,[dateofaudit])) & " Qtr -...

I converted the db to 2000-2003 format for you. Thanks!

I have added my db which is a very simple one except for the code. I hope this helps.