Search results

Hi - I have MS Access on my PC however wish to move the accdb file to a network location to allow other network users to have access to it. Unfortunately a few of the other users do not have MS Access. Is it possible for them to still open the database without any admin or background - I would...

Hi - i have a query with the following code which searches the 'BookingDate' field for records between two dates: Between [Forms]![FilteringForm]![txtStartDate] And [Forms]![FilteringForm]![txtEndDate] this works fine however if the user doesnt put any dates in either box how can i return all...

My subform filters fine with combo boxes. One of the fields in the subform is a date which I would like to be able to filter from a txtStartDate and txtEndDate. I'm using the following code but I cant get it working (getting an error code 3075) Public Sub SetFilter() On Error GoTo...

Hi, I have a listbox which is filtered by combo boxes which works fine - the list box filters when the content of the combo boxes exactly matches data in a column of the list box. I use the following code to filter the listbox: If Not IsNull(Me.ArtworkSource) Then strFilter = strFilter &...

hi guys as the title suggests - my outlook has stopped selecting the first email in a folder when its opened - for example when I used to click on my sent or deleted items folders it would automatically highlight/select the top/first email in the folder. any ideas??

Hi guys I think i already know the answer to this but thought i would check I have placed a database in a shared folder on a server for other users to use. Is there a way for them to use the database without having MS Access installed on each machine (they have MS Office but not Access)...

Hi guys I have seen various threads about setting an outlook reminder based on an appt table and then a form. All i want to do is have a command button which opens outlook and opens a new appointment in the calendar for the user to enter the reminder information themselves. Is this possible...

Hi guys probably pretty straight forward but cant seem to get it going... i have a command button to click to send an email to the email address in a field. it works great unless the user has not entered anything into the textbox. and im getting an error if the text box has normal text in it...

Hi guys feeling a bit stupid today as i cant figure this out and its pretty simple. i want my checkbox (Exchanged) to be ticked if a date field (ExchangeDate) has had a date put into it. otherwise remain false/empty. ive tried an if function on the after update event of the field...

hi guys i have a database that has a checkbox if the stock is in stock. once this item is sold the box is unchecked. for security reasons i wantit to request a password when the checkbox is unchecked so that only tha managers can remove stock from the database. ive had a little search around...

Hi guys With some help i had previously been able to make a button on my form that copied that record to a new record (depending on which check boxes were ticked). It all worked ok but after some more work on the database im getting a runtime error 438 when trying to run the command button. I...

Hi I have a report with a few hidden textboxes because they are controls for a long calculation. However in the report every record shows the same calculation when it shouldnt... Im trying to create a report for multiple records. My calculated textbox is...

Hi I have a stock items in the database that I want to duplicate over and over (all but a few fields are the same e.g. same thing but different size and price) I want to a command buttong to open a new record in the "add new" form (frmTicketing) and enter the stock item with the same...

Hey I have a form with two calculated fields (based on other fields in the form). When changing these other fields the calculated fields do not update - only when i save, exit and reopen the form to they change. What code do i need and should it be after update on or on change?? Is there a way...

Hey guys had a search around but cant find the answer just yet: Got a search form that when the record is double clicked it opens a form (via a query) with that record - ready to be edited. On the opening of the edit form i get a data type mismatch in criteria expression message box (however...

Hi All Is there a full list anywhere of all the DoCmd. or statments or conditions that access uses anywhere? For example, a list of Else statements to be used with IF. Or a list of DoCmd. or a list of what IF can be used to look for/find. I think it may be useful in answering many questions...

Hi All Ive read so many appointment and calendar threads on here and still cannot find what im looking for. I used to work for a company who had a system that used/was based on MS Access. They had created a proper appointment diary where bookings and appointments could be "clicked n dragged"...

Hi all Can someone point me in the right direction for code to go on the onclick event of a command button to insert some text (e.g. "yourtextgoeshere") into a text box (e.g. txtbox) on a form (e.g. frmtest). And btw, I want to be able to add to the text that is already in the text box, not...

Hi all I want to show/hide records in a listbox depending on which command button is pressed. I have 5 command buttons and column 3 in my list box refers to each of these command buttons (1-5). How do i display the records in the listbox that match that ID/command button? I was think of...

Hi all Having a stupid little problem - The currency and decimal places are not showing up my listbox. In the table that the listbox is based on the field is set as currency but its not showing up, any ideas? Btw, i looked at other similar questions but someones posted a db that was supposed...