Search results

Hello, i have a excel spreadsheet that has a column with a persons surname (comma) and firstname i.e Steve, Jones. I export this spreasheet in Access, but would like to splitt the surname and first into separate columns in the table.. whats the easiest way to do this?? Thanks

My new plug and play barcodescanner outputs a string of numbers and a Carriage return....tested with notepad and it works fine! I have got it set up to fill a textbox on my Access form, but im having to scan my barcodes in twice the before i get it to update records in my listbox. I have set...

Hello, just need some help correcting the syntax with the below. Vend is the name of my input textbox on my form, but the value entered will not copy into my table 'Notsent' Can anyone spot why? Thanks. db.Execute " INSERT INTO Notsent " _ & "(Vendors) VALUES " _ & "('&Vend');"...

Hey all. I have 3 files on my c:\ drive work_040607.xls work_050607.xls work_060607.xls What i would like to do when my access app starts, i click a button on my form and all work_*.xls files from my directory that have a date greater or before the current date are deleted. So, if todays date...

Hello, Could someone advise me how to fix this little problem i have when importing a spreadsheet. My app outputs two columns into a spreadsheet with the following US date formats. The spreadsheet it generates is called dates.xls, and i need to re-arrange all the dates in the spreadsheet to a...

I have a textbox on my form and the forms record source is table1. I have a second textbox on the same form, but i would like to make its record source table2. What is the property i need to change to make it write to table2. Thankyou

hello, i would like to design a simple form that will show the date in say 7 weeks, if i enter 7 in a text box, if i enter 6 then it will show the date in 6 weeks time based on the current system date.. i understand this may need a calender function so any help appreciated! cheers!

Hi all, I have created a database for work in Access2003. I have two questions. The first is, many people at the work place use AC97 and some use AC2000. In order for everyone to use the database, i have saved it in AC97 format. It seems to open fine in Ver2000 and 2003, but i get this nag...

Hi all, i have a form with a header that contains a few data entry txt boxes and a search button, with the body of the form returning the filtered results of my search criteria. Now i've had to set the form properties to Data entry to allow data to be entered, but it also allows the filtered...

Hi all, i have a form with a header that contains a few data entry txt boxes and a search button, with the body of the form returning the filtered results of my search criteria. Now i've had to set the form properties to Data entry to allow data to be entered, but it also allows the filtered...

hi, im using codecontextobject to write data directly into the record column in my table. I cant get it to write today's date into the record though? i've tried [Date] = date... any one know? thanks with CodeContextObject [Type] = x + 100 [Date] = ?? end with

hi all, in code, how to do i make a report close automatically if it detects no records are contained within it. The report is generated from a query. thanks

Great forum guys! Just had to join it :) I've been doing Access for just under 2 weeks now, so far I'm doing ok, but I've just run into 2 problems. I hope someone can help me on them. The first problem is on a query. I have a Column called "Type" in my query and the choices under Type could...