Search results

Hello, I have a continuous form that shows all the records from TableA. In the form header I have added multiple filtering options using either text or combo boxes. Each filter uses the following VBA executed by a button: Me.Filter = "[Priority] Like" & "'" & Me.Combo94 & "*" & "'"...

Unfortunately due to security reasons I cannot upload anything from this DB. Although, I have found a temporary solution to the issue: When the form is opened, the records cannot be edited or updated, etc. But when I run a filter, then clear the filter with VBA, the form goes back to being...

Hi JHB, Thanks for your reply, I'll try to clarify the best I can. Normally, when the form is opened, the user can add new records, edit records, delete, etc. The "Allow Edits" property has always been set to "Yes". Now, in Access 2010, when the form is first opened, no new records can be...

Hi there! I've got an odd issue here: I have a continuous form that displays 1000s of records, each record has multiple check boxes, text boxes, combo, etc. When I open the form using Access 2010 - it is defaulting to a 'read only' state and I cannot edit any of the records. A weird fix -...

Could you give me a quick example as to how I would do that?

Hi All, I have a table with RMA (Return Merchandise Authorizations). This table has many fields, RMA #, Serial Number, Return Date, etc... My goal is to find how many serial numbers have been returned annually over the last 4 years. Most serial numbers are only returned every 2 years, so I...

Hi and thanks for your reply! I've changed the filter string to "" before turning off the filter. I have discovered that when no records are returned for any of the filters, the form shows as 'filtered' and becomes read only, when I run the Command76 to clear it, the form goes back to normal -...

Hi All, I have a continuous form based on a query (the query has 2 tables with 1 relationship, it's fairly basic). The problem is sporadic, which means I can't figure out the trigger causing it, but after the user filters the query either by serial number, or customer, etc... the form will...

Hi MarkK, I just use a simple macro to backup the backend file to my local machine, although I'm sure you can back it up wherever you like. I use a timed backup, so the top of every hour this macro runs: For the condition: Time()>=TimeValue("07:00:00") And Time()<TimeValue("07:01:00")...

pbaldy, thank you very much for your help!

Yes this works! Thank you kindly! So moving forward, is there anything different I will need to put in the SQL statement to update checkboxes from the same form?

Hey thanks for your prompt reply! I tried the debug and this is what it gives me in the immediate window: mySQL = "UPDATE BT200 SET Part = '" & SO & "' WHERE Item = " & ItemNo UPDATE BT200 SET Part = '21515' WHERE Item = 21515-01 The Part and Item are both coming out as I intended them to...

Hi All, I have a table with many records, using a form with an update button click event, I would like to update ALL records where the Item in the table = the Item in the form. There are 6 checkboxes and 6 text boxes that will need to be updated, but right now I am just trying to test if i can...

Hello All! I've never done this before, so I wasn't sure where to start looking. I have a .dat file which looks like this: 316 Canada 366 United States 232 United Kingdom 503 Australia 218 Germany 211 Germany 219 Denmark I need to extract these so that row 1 = 316(Column A)...

Thanks pbaldy! I actually just found the thread I needed right after I posted this at http://www.access-programmers.co.uk/forums/showthread.php?t=191670 Thanks kindly for your help! d

Hello all! I am having a bit of a hard time with this: I have a form (vp1) that is a continuous form based on a select query from multiple tables (TableA, TableB, TableC). Now I have created TableD. From form vp1, I need a button on each record that when pressed, opens a new sub form...

Hi All, I am just wondering if possible, how to create a hyperlink on our product page to search the directory for the newest file in a particular folder. We upload a new software revision to this folder from time to time, but we want to keep the hyperlink on the page the same, which is...

I have a line in the code to cancel / close the report if there is no data results in the query, but I do believe i solved the problem... I went into the setup table: ReportFolder = DLookup("[WO Report Folder]", "Setup", "[ID]=4"), and deleted then re wrote the destination folder for these...

i will give that a try. On another machine, i don't have any problems saving the report to the same network folder, so i'm not sure this will help, but i will try anyway.

Thanks for your prompt reply, I tried those suggested fixes in the link you sent, but i'm still getting the same error. I just realized that this error is also now happening on my Windows 7 machine, it worked fine on June 1st, but now on both computers it's giving me the "output to action...