Search results

Morning/Afternoon/Evening all. Need a bit of advice on the best way to approach a report. I have a report which gives a sum total of check boxes. The boxes are Letter_1_sent [Yes/No] Letter_2_sent [Yes/No] Letter_3_sent [Yes/No] Letter_4_sent [Yes/No] Letter_5_sent [Yes/No] Now this is fine...

Howdy Folks. Hopefully an easy one. I have a report with the fields Firstname_ Surname_ [field1] [field2] etc etc (they're not called field1/2 but they're irreverent at present. On the database people can be entered multiple times so I may have Bob Smith Jimmy Carter Bob Smith Jackson...

I agree, This is just a test I am working through as a proof of concept before we work on the life database

Yes.. it seems funny but I'll explain it to you. I have a table with four columns, it has ID (not used) Postcode Drop Number Last Drop Date The postcodes contained in the table is for an area covered by 15 offices and has drop numbers set to each one for the numbers of drops and will then...

Sorry my mistake for posting so obscurely and via Mobile while rushing around. So I have a Combo Box, You select a postcode in the combo box and hit a button, The button runs a query Private Sub Command12_Click() DoCmd.OpenQuery "SELECT Query" End Sub Obviously as it just runs the query a...

Hi Guys, Hopefully this will work. We have a button running a SQL query via VBA, how can I make it so the results doesn't show up in a table/preview? Also, I know it's for the SQL forum but how can I make a text box to show the results of a query to display it on screen?

Thanks, both the posts help so much. Never used a continous form so I will look into it. Thank you. and the PDF print is great, I'd love to be able to use the outlook function to send it as an E-mail but a lot of people use OWA (Outlook Web App) so doubt it'll work with that, May include both...

Hi there, sorry I posted in a rush, The main thing I am having trouble is adding the extra line button, I have no idea where to start from here The two DB's are because they are being used in two physical locations, the branch location will not have access to the server hosting the HQ copy and...

Hi Guys... I am creating two databases currently (there is a reason it is split) One will be located at an off site location (ie branches) so we have Branch A Branch B Branch C and so on. One will be located centrally at HQ. The databases will be used slightly differently Database One...

Hi Folks. I am working on a new project involving two separate Access DB's. One will not be storing data itself, just used to create an initial order which is passed onto a person who processes it (their DB will store data) (I am working on the ordering one atm). It is designed to be able to...

So I found this on Google "Access looks at the first row(s) to determine what the rest of the column contains. If it sees all numbers, it will import it as a number. If any subsequent rows are text, the import will fail on those records." ETA: Did this moved one with mixed...

It does create an import error with three fields, it gives me "Conversion Error", "Field name" and "Imported Row number" no other details.

I also just tried it into a fresh clean DB, let it create it's own fields into a new table and once again, same import errors.

That's the thing, as far as I can tell they're both set to "General" http://s25.postimg.org/i4e006skf/excel.png http://s25.postimg.org/p6bxmdw67/Untitled.png Top link is the excel, showing it's set to general. Bottom is the field set up in Access Problem is, this never...

Thanks, so simple.. worked perfectly However, on a side issue I now have. Some data can not be imported due to a "Conversion Error" all the numbers from that column get imported but anything with letters isn't imported. The field it is going into is set to "short text" which is...

Hi, So I have a new DB set up, tested and working and we're happy with it. However I am having difficulties importing from excel into the existing table and choosing the fields to import into, I have 7 excel spread sheets to into in to the one, each with around 5,000 entries. When I...

Shadow, Thank you so much for that. I never checked back before doing a batch file myself. For anyone who is curious I am using this code and it works perfectly. @echo off for /f "delims=" %%a in ('wmic OS Get localdatetime ^| find "."') do set dt=%%a set DD=%dt:~6,2% set MM=%dt:~4,2% set...

Okay, any idea how I could add todays date onto the file name when using a batch file. I know how to do a simple copy with something like copy /Y y:\[FILEPATH]\DB.ACCDB y:\[FILEPATH]\Backup\*.* But obviously it'll use the default filename.

Hi everyone. Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010) Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up, but thought I'd check...

Looks good to me, Thanks Gizmo