Search results

Hi There, Can you help me please. I know how to loop through a list and get the rows that are selected but I need to know how to loop through a list and mark rows as selected. I have a list with say 4 items in it and if the user changes their mind and wants edit and add more to this list, I...

Hi There, I am creating an Sql select statement using a string variable. I am receiving an error that there is something wrong with my select statement. When I take a look at the string it's cutting off at 255 characters. Is there a way to get over that limit? Thanks for the help...

Hi There, Could anyone help please? I currently have a form where after filling it in and clicking ok, there is a select statement executed that adds related records to a datatable. I need to interrupt that select statement to allow the user to pick which related records they want to...

Hi There, I have a form with a number of entry fields and after a button is clicked I write to an MS Sql datatable. Everything works fine as long as I put a value in each field. If I do not put a value in one of the fields the sql does not run and the record is not added / updated in the...

Hi There, In need of your help again. I have a form with a list on it called Lst_Areas. I can multiselect from the list and then click a button which opens another form for me to do some work on the selected list items. Once I am done and close the form which takes me back to the form...

This is odd. I am updating an Access program and I work from home and office. For some reason when I bring my work from home to the office and go into the app everything works fine I can choose from lists go into forms but I cannot type in those forms, its as if the keyboard is locked...

Hi There, I don't know what I have done but in a particular form I am unable to type into any of the fields. It's as if the keyboard has stopped working but it hasn't because I can type in other forms in the same app. Have I accidentally hit a setting that stops input into the form...

Hi There, In my Access app I need to get the latest record added of an item from a MS Sql table and check the period between now and the date saved in the record. So my guess is: Select TOP 1 * from tbl_StockItems Where StockId = Loc_StockId I then need to check the days between...

Hi There, I Have taken over an Access program and I have been asked to create a password policy in the program. There is already a login screen but this just checks the credentials against a MS Sql database. I need the password policy to be a bit like the windows policy where a user is...

Hi There, I have taken over an Access database and I am having a few issues finding where things are being pulled from. On all the reports there is a menu area with icons with Page Setup, printer, and a button "Output" which when you click it drops down and gives you options to open in...

Hi There, I have an Access app that users need to log into so it has a login procedure. Now I am being asked to convert it to use single sign-on. Would anyone here be able to guide me on how to implement this. My MS Sql database has a user table with username & password but I am not sure how...

Hi There, I have been doing some coding on an .mdb and I set it to not allow the users to be able to use alt+F11 or F11 but now I cannot get back in to make changes to the code. Is there any other way to get into the development area of the .mdb? Thanks for your help. Best Regards,

Hi there, I have just updated my laptop to Vista from XP and now Access programs that used to work are behaving oddly. I have a main form, with buttons on, that would call my forms but now when I click on the buttons no event fires, I just stay on the same form. Another DB had a form with...

Hi There, I have been asked to develop a new application (not using Access). I have the original Access Database and while I can get the data out I was wondering how I can get the images out of the database. Any help you can give would be appreciated. Best Regards,

Hi There, I need to deploy an Access db to about 8 PC's in a domain. I use the "Linked Table Manager" to set the connection details to MS Sql Server using an ODBC data source. My problem is when I have it running on 1 PC in the domain I thought I could just copy it and put it onto other PC's...

Hi There, Can someone help please. I have taken over a database and I cannot change the table structures. The backend database is MS Sql Server. I need to build a couple of queries but cannot get them to work. In a table I have 2 fields EntryDate & EntryTime both are datetime. The...

Hi There, I have a report that shows a datetime field and I would like to show only the time portion of the field on my report. Is there a way for me to do that? Thank you for any help you can give me. Best Regards,

Hi There, I have taken over the maintenance of an Access Application and the client wants to have single sign on. At the moment the users logs into the Access system by giving a username and password. The client wants as little work as possible and I was wondering how access can get details...

Hi There, I have an Access database that is using MS SQL Database as the backend. I need to run a query with an order by ClosedDate DESC When the query is run from an Access Procedure the data is not showing correctly on the report but if I run the query from within the Access designer it...

Hi There, I have a datetime field called EntryDate I need to write a query where EntryDate = today and the time part of EntryDate is > 09:00 and < 18:00 I have tried the criteria in the screenshot attached but the date part will not work unless I put in the exact date and time of the records...