Search results

Hello guys and girls, it has been a while since i was around. Hope you are all well? I have a BE database whose tables overtime have become the source data for several excel spreadsheets and been linked in other FE database. Is there any way to see active connections to the BE database?

The context here is at the point of closing a case. The agent is required to record the method used to resolve the case (to be used as 'library' for future cases). Whilst retrospectively the call center manager can keel haul lazy agents, it then takes time to remember and update the entry (which...

Thank you all for your inputs. I was hoping someone, somewhere had figured a way to check for this. But as Linq pointed out, i had really already answered it:rolleyes: I did find a list of pairs of consecutive letters that do not show up in words in the English language, so i have added that...

Thanks Colin. Thought about using spell checker, however there are a lot of abbreviations used (different users use different abbreviations!) so can not 'allow' for that. Plus the environment is a call center and they are not too bothered about correct spelling!

Hey gang :p I am looking for a way to check a string for gibberish. So aaaaaa, bbbbb, lsdjadjlajdkljas etc is not allowed. Now i have done this thus far for aaa bbb etc by using INSTR() through a loop through an array, but obviously you need to anticipate EVERY conceivable piece of gibberish...

How are you setting the filter on the details subform? Is it a single record on a Single Form OR multiple records on a Single Form OR multiple records on a Continuous Form? Have you changed any of the Data properties of the subform eg Allow Edits, Allow Additions, Data Entry etc?

Not really sure what you are asking. Your queries can already 'see' the data in the current table :confused: Are you referring to duplicated data? So a query may return multiple rows of same data? If so use the DISTINCT or DISTINCTROW predicate in the query SQL.

Do you have forms, queries and/or reports that reference the fields you want to split out? That would make things more tedious. I guess it comes down to the number of objects you would have to change. The basic principle to split a table would be to run a Make Table query, adding all the fields...

Ah! So that pretty much goes back to me first response, FileCopy function. FileCopy(Source as String, Destination as String) So you can either provide source and destination paths OR you could use the FileDialog method to obtain the destination path. the below code will prompt the user to...

Sorry i must be really dense today. if you were doing this manually; Navigate to file in Explorer Right click copy Open another application Paste file Is this right? Do you want to paste the contents of the file to the other application or just the file path?

So you want to pass the filepath of a file to a procedure, have it open the file and copy the contents onto the clipboard? What file type is the file you are copying and what is the application you want to paste into? If this is excel to excel, then simply use the filepath to open the...

Do you mean copy the whole file from one location to another (FileCopy function?) OR copy the contents on to the clipboard for pasting into another application?

Just an update for you all on this one. The IT team cannot identify any reason behind these issues :banghead: However, they did find that by saving to file locally and then using FileCopy to transfer it to the 'correct' folder on the server, everything is fine. I have marked this as solved...

laluna, you basically already have it in the coding you've got. Put the below code in the after update event of the checkbox Private Sub Check15_AfterUpdate() Me.Requery End Sub This will hide the just clicked record if you are displaying Checked=FALSE OR if you are displaying Checked = TRUE...

Right so to make 1 or more records not visible, you need to provide a criteria so the form knows what to 'hide'. This goes back to post #4. So, what is the RecordSource of your form? Table Query If a table, then you will need to set a filter on the form. If a query you need to add the...

Almost dude. Dim FileName As String Dim strpath As String FileName = Me.Blanket_agreement_Number &".PDF" strpath = "c:\Filepath\" & FileName Application.FollowHyperlink strpath

OK,lets check what you want to achieve and what you mean by disappear. Do you mean for the record to be PERMANENTLY deleted? Do you mean for the record to not be visible?

Do you need all the data to show at any time or just the unchecked records? The way to do this is to either filter the data on your form so only records where the checkbox is false show OR (and possibly the better method) create a query to use as the recordsource for your form and have the...

is the checkbox bound to a field in the forms RowSource? I would use the checkboxes afterupdate event to refresh/requery the form.

Not too sure what you are asking here. Do you want a query to return records where the difference between [EndDate] and today is 3 months? if so the DateDiff() function should help with this.