Search results

I have a Form with tab box of 6 pages, the default page apart, each of the other 5 pages has a listbox, and the SQL for each listbox is a bit heavy and can take the page a while to load i have the code so that once i have opened a page, go to a different page, and go back in that page, the...

Hi on a form i have 4 list boxes in a line side by side, beneath these list boxes is one button, and beneath the button is 4 list boxes side by side what i would like to do is have the button top value just below the largest height from the list boxes above, which is driven by the listcount...

1st, i have tried to search, but i am not sure how to title the search i know what i want to do, but dont know the full correct access terminology hence please bear with me i have a table of 120,000 records. each record is applicable to at least 1 part, therefore i placed a FK in this table...

Hi i have an access 2013 unbound form, for which the aim was to record certain information from a pdf file. so rather than load the fields with information copied and pasted from a pdf, i would like to show a pdf in a web browser, the file location controlled by a location on a txtbox...

hi I am trying to resurrect the use of data i previously used with good effect that was stored on sql server from 6 years ago, using access 2013. in the sql server database i have a list of approx 100,000 document references, each document may have more than one revision, so i have another...

hi, i have a few questions on using a popup form 1. on my main form, i have a listbox, i would like to edit the values of the listbox. to do this, i have a popup form with 2 listboxes, one to have the values of the listbox on the main form, and the other listbox with option values for the 1st...

Hi a few years ago, i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text i made the mistake of not copying the files for...

Hi Just started to create ribbons in AC2007 manually in table USysRibbons my question is can i have different ribbon tabs for different forms, in the same way i could have a specific menu bar for each form in Access 2003 i am going to download the IDBE RibbonCreator trial, which looks very...

Hi How do you set the form caption for an access 2007 form i have moved from ac2003 to 2007, and now the form caption names have disappeared. in ac2003 i could get [database name] - [form caption] now i just get the [database name] thanks roosn

hi i use a sql server back end through ADO to populate list boxes, all works great with the exception of: number formats i need 2 types of number formatting one for total hours and minutes such as 12345:45 and one for a straight number such as 34456 or 00012 because the listbox columns...

hi i have over 20 forms in my access 2003 front end database i use unbound forms on these forms i have 3 text boxes tb 1 is named tb_lbk_id1 tb 2 is named tb_lbk_date1 tb 3 is named tb_lbk_hours1 i open a pop up form which has a list of dates in a list box. in order to transfer values i use...

hi i have a date field in sql server 2000, smalldatetime data type what i cant get to is the hh:mm for example 31/08/2005 12:01:00 using CAST(DATEPART(hh, dbo.tbl_log.date) AS varchar) + ':' + CAST(DATEPART(mi, dbo.tbl_log.date) AS varchar) i get 12:1 what i require is 12:01 thank you in...

Hi How do i store a file directory i can store a file, make a directory, but i cannae find out how to store a directory path many thanks roosn

Windows XP SSQl 2K BE A2003 FE Hi i have 2 list boxes on a pop up form they both using ADO queries as their source, i use the left hand list box to search for documents and add selected documents to the right hand list box, which will synchronise with a main form form. i also delete some...

Hi how do i make my list box actually show no records when the recordset returns no records after a query, when the recordset has no records, the text box caption states to say "No Records ......", but the list box does not change to show nothing i have the following If Not (rs.BOF...

SQL server 2008 express Vista Access 2007 Hi What am i doing wrong trying to create a project using existing sql server database enter a server name, same as the sql server express 2008 server name. Security set when i try to select a database on the server i get a data link error...

In 2003 version, in form view, i can right click on an object such as a button, list box etc, and thru properties edit the code can i do it in access 2007. running the trial version for now, so not sure if it is inhibited until i can get home make the decision for a full purchase

Hi can i use a configuration of Vista OS, sql server 2008 express backend with a access 2003 front end my new laptop has access 2007 and i have taken an immediate dislike to it and the other 2007 applications

Access 2003 FE Sql Server BE Hi i Can loop a listbox to create a pass thru query using strCriteria as the parameter as thus ' Loop through the selected items in the list box and build a text string For Each varItem In Me!lstActual.ItemsSelected strCriteria = strCriteria...

Hi All i am using a access FE with a SQL server BE I am okay using DAO to supply data to unbound forms and update any changes made using these unbound forms However, to populate the text / combo boxes on the unbound forms on opening i am using dlookup's is there a better way ? many thanks...