Search results

Hi there, Is it possible for me to store VBA Code in a table and execute on a form? For example: My table contains a field called VBA, that field contains the following code: Docmd.Quit is it possible to reference that VBA Code on a form? e.g. a button that will reference that VBA code from...

Hi All, I currently have a CSV Table consisting of 30 fields linked to my access database, now and again I need to add additional fields. but each time I do this I'm having to relink the csv and rename all the field names etc.. Is it possible for me to add a new field directly in the CSV...

Hi there, I am unable to link MySQL database to my local Access Database due to having a Dynamic IP (not the best of providers we chose)...anyway I had a thought! Is it possible to export a new appended record to a .php file which then sends data to MySQL via a hidden browser? sounds very...

any ideas? sorry to pester, I can porgress futher until this issue has been resolved

You you try Lymm or Carrington both of which are in Manchester but in the countryside Lymm is very nice!

Hi All, As the title says, i'm trying to requery a subform after update from a another subform which are both within a main subform that is on a main form. I have attached a image which makes it alot easier to explain on what i'm trying to achieve. (Please see image) goal is to requery...

Apologies for the post, I found the answer on here..I did a bit more digging using the search Formula I used in the end: =-Sum([Risk Rating]="Red") *Note "-" next to = to avoid having a negative value.

Hi All, I'm having a right time trying to figure out the following. I have placed a text box in a subform with the following: =count([Risk Rating]) and a textbox in the main form =[QryRisk_Subform].[form].[Red] I'm trying to filter =count([Risk Rating]) again by adding "Red" at the end...

Hi all, I'm currently using the following VBA to export all tables within my DB to Excel on seperate tabs: Dim td As DAO.TableDef, db As DAO.Database Dim out_file As String out_file = CurrentProject.Path & "\" & "Backup.xls" Set db = CurrentDb() For Each td In db.TableDefs...

hmmm..i've created a subform on my main form that contains the query. how would i apply that code?

Hi there, I have a query that lists all tables within my access database. what i want it to be able to click the table name from the query list. for example my query list is: Rawdata Outcomes Reporter Tracker how would I click on Tracker and open in up the tracker table?? is it something...

I fixed it! Yay It was due to users adding carriage returns in the memo fields. I added a function to take care of it before the table is exported.

Thats correct, I wanted the body of the email (delimited text) go to master table into relating columns. So what i have down is export the email to .csv as soon as it comes in, then link the csv back to the database where the wizard creates all the columns for via the separator. Then append to...

I really need to find away to remedy this issue as I need foward the data as and when it comes in to my colleagues....are we getting to the idea that it may not be possible?

Hi this one is different to the other thread as there are no characters that cause linebreaks that i can see. Basically I have linked Outlook to Access where it automatically imports new email. Each email contains Delimited Text So i append the delimited text to a table Export the table to...

When I use the import wizard it sends some of the data to another row. i'm not sure whats casuing the line break. when all the data is seperated by "#" what do you think?

My apologies I thought it would be best to provide a simple table as an example such as ID#NAME#AGE#DOB#EMAIL where I could then adapt the same principle to the current test db Apologies again, I really didnt intend to mislead you..All I do know is that i'm very thankful to both yourself and...

where there is ## or ### is where the user has left that particuler field blank...I need them to be included incase some does fill in the data. Think there are around 71 fields or should i say 71 #

I've now uploaded a test db I've used a different table in this test db, i.e. there is more delimited text split by "#"

So i've created a query in design view. Added the table to the query that contains Delimited Text The field that contains the delimited text is call "Contents" So if i add "Contents" to the first field of the query, the query only displayed one field that contains on delimited text. ---------...