Search results

the database window may be set to hidden on startup. Go to Window/Unhide abd select the db. Also look in the Tools/Startup pareters and see if it it is set to hide db on startup.

set the record/row source of the combo box to your query

create an append query to copy the data

the path/name need to in the main loop. At the moment you are setting it up once prior to the loop

you have an extra comma DoCmd.TransferText acImportDelim, "Tablogs", filename, True

I've done something similar, with a spreadsheet. Email that out. Set it so it is protected with only fields for data unprotected, when you receive the spreadsheet back use vba to open the spreadsheet and read in the data.

Access cannot import dates as text without the day i.e 01/02/2009 is valid but 02/2009 is not. Access always expects the full date. You could import into a text field add the day to the date then append to the data table.

Another thing to try open each table directly and give each record a visual scan, what you are looking for is a corrupted record, and usually you will see #Error# in one of fields. If you do find one, then you will not be able to remove using the DEL key, instead create a new table and copy /...

First you need to execute code everytime the db is opened. Either use an Autoexec Macro that calls a function or a hidden form. that call the function GetUsergroup(Username) The step to take in the code are as follows 1) Obtain the user name and you get this from the function CurrentUser() 2)...

replace the ANDs with ORs

If I read your post correctly, our problem is not with surveys but how to apply permissions. What I do is to assign users to groups within a workgroup file. Then when a user logs in I determine what group they belong to and restrict access to forms and/or data as each form is opened.

the link should be in the tables if you have correctly designed them (which I don't think you have.) A typical table schema would be, PrimaryKey, StudentSurname, StudentForename, StudentDateOfBirth, StudentAddressLine01............ The Primary key is then use as a Foreign Key in any related...

You need to develop a sequence query to create pseudo record numbers (these will be unique each time the form is opened). However I do not know if that type of query is updatable. I posted two examples of sequence queries last Fri I think.

Two Ways to do this. 1) Use a query as the record source for the form and add the table with the surname to the query. Then link it to the student and add the Surname field to the query grid. Then on the form Set the text box to read only and bind to the surname. 2) use a DLookup Function to...

Your problem is that if 10 people live at the same address you will not have enough room on the line for all the names.

Your Help Desk form may be corrupted. If you are getting the error message with any form then it may be a permissions problem with the network share. Sometimes however it is impossible to un-corrupt a form and you have to re-develop it from scratch.

Pat, Don't forget that when the db was recovered the all auto number fields where converted to integer fields, and my understanding is that to reinstate the auto number I had to create a new autonumber PK, and of course because records had been deleted after a while the new autonumbers became...

Several Years ago I was asked to look at a db that had become corrupted. The corruption was so bad I had to use a 3rd party tool to recover the data. Although all the data was recovered the autonumber field and all indexes where dropped by the tool. So I had to regenerate the autonumbers and...

Hi, There are two things wring 1) strSQL = strSQL + "WHERE tblAnsweredQ.ID = tblProducts.[ID] " If you require the value from tblProducts.[ID] then the corrected way to substitute is strSQL = strSQL + "WHERE tblAnsweredQ.ID = " & tblProducts.[ID] & " " 2) strSQL = strSQL + "AND tblAnsweredQ.ID...

try the onenter Event (or Gotfocus) for the subform on the tab. or when the tab is clicked you still get an event for the tab control so you can determine which tab has been clicked. I have done this somewhere in my 100s of dbs, but I doubt I will be able to find it easily.