hi, i tried to search for this, because i am sure this has been asked before, but the search feature of this site is not working
i was wonder how a table can read and write data for all of its field from a text file
Shokoth
Last Activity: May 2 '07, 11:34 PM
Joined: Apr 17 '07
Location:
-
wrting data into access from text file
-
swf file in switchboard and forms
hi
i was wondering if its possible to have swf flash files imported into access, i tried to use it once, but i recieved the folloing error message the object required is not registered.
is it possible to have a small swf file in the main switchboard -
If i put it in a different line, and put the word AND infront of it, the statement infront of the AND does not update, but the rest do
Is there any special characters that we need to use -
sql update statements over several lines in vb
I also wanted to know how to spread out sql statement over 3 lines.
I am writing an sql update statment in VB.
I have about 12 fields to update.
[code]
strSQL = "UPDATE [tblServiceUserP ayments]" & _
"Set [tblServiceUserP ayments].[January Payment] = DateSerial(Year (Date()),1,30), [tblServiceUserP ayments].[JanPaymentRec] = False, [tblServiceUserP ayments].[February Payment]... -
thank you for your help
I also wanted to know how to spread out sql statement over 3 lines.
I am writing an sql update statment in VB.
I have about 12 fields to update.
[code]
strSQL = "UPDATE [tblServiceUserP ayments]" & _
"Set [tblServiceUserP ayments].[January Payment] = DateSerial(Year (Date()),1,30), [tblServiceUserP ayments].[JanPaymentRec] = False, [tblServiceUserP ayments].[February...Leave a comment:
-
date default value
Hi, i want to set a default value for a date field, and i want it to be 01/01/(current Year)
how would i go about doing this.
so if the current date is say 22/04/2007
i want the default value of a field to be 01/01/2007 -
i have tried the following statment in the query maker
([tblJobs].[start date].[month])=Month(Now())
But this doesnt work, as the search results are empty.
I want it to show all the jobs from the current month, and i am stuck on how to go about thisLeave a comment:
-
Need Some sql or normal access query help
Hi
This question may be a bit obvious, but in a query, how do you show just the month of the current date. I am trying to retrieve records of a certain month.
Date() will show you the full date, but how but jus the month. I tried checking in the properties but they dont have an option just to show the current month.
Is this possible, just to view the currrent month of the current date.
If anyone would be... -
i have a listbox with employee details, and it is in a form that allows a manager to assign employees to a particular job.
so when the manager double cicks the list, the employee that he has just clicked, the name on the employee is added to the form, an is added to employee one. once the manger clickes the list again, that employee is added to the form, on the text box employee 2, and so on.
firstly i am not sure how that would...Leave a comment:
-
update sql statements using loops
hi
is it possible to have an sql statement with a loop. i am trying to update several fields at once based on a form.
the criteria would be that if the value on the current form is the same value in another table, then set field to ..... -
SQL inserting into multiple fielsds
hi
I am trying to inser data, from a list box, to a form, while the form is running.
i know how to do this, but i am a bit stuck on a different feature of this.
I ahve a form, with multiple textbox, i.e.
employee 1 (Text box for data input)
employee 2 (Text box for data input)
employee 3 (Text box for data input)
so on to employee 10
... -
I tried both of these,but it stilll didint work, but i worked a way rpound it.
Created a textbox, made it invisible, and once double cliked, the value of the list.coloumn is written to that text box, and that value is then inserted.
Thanks for the helpLeave a comment:
-
i still get the same error.
within the main form,there is a list, a tabbed frams, and the actual form.
i am trying to insert data from a subform inside the tab control, a list box and the actual form itself.
is that possibleLeave a comment:
-
SQL Insert Help
Hi,
i am trying to insert into a table, at run time useing a form. i am using the following line:
strSQL = "INSERT INTO [tblRequestRespo nse]([Request ID], [Service Offered], [Service Provider], [ServiceName], [Description], [CostPerHour]) " & _
"VALUES (froms![frmServiceProvi derInfo].[lstRequest.colu mn(0)], Forms![sbfrmServices].[ServiceID], Forms![frmServiceProvi derInfo].[tblMembers_User Name],... -
Open mail merged document in a form/report
Hi, i am trying to open up a document, that is already mailmerged with the correct data (and fields).
I have written the letter, and added the relevant table source, along with the required fields, and it works. once the mail merge button is pressed, then all a letter is developed for all of the related records.
i then tried to open that by putting a command button in a form and a report, and in the form, only the program oopens.... -
How would we go about doing that.
What varialbe should we declare globally. is it the username (entered in a form), and the user name in the table?
then refer to it, where all the forms use that username?...Leave a comment:
-
thanks.
I am also trying to open up a from in add mode, from another form.
i have one form, and wen u click a button, it should take you to another form (from a different base table), and open that up in add mode.
I have tried a few several ways, but it doesn't work.
How is the solvedLeave a comment:
-
sql error message
Hi
I have been trying to run this code, and what it is doing is inserting records into a table called tblRequestBySer vice. the values that it is inserting are taken from the form itslef (They are normal text boxes). every time i click the button to do that, i get the folling error message:
"Number Of Query Values and Destination Fields are not the same". I have been having similar problems throughout. i know that the... -
Administration/security levels in ms access
Hi
I was just wondering if there are any tutorials or any help available to help me set up administration levels (security levels), whereby i can give different types of members different access to the db. for example, the admin can do whaeva he wants, but if a customer logs in, using their details, they are restricted to onle view certian aspects of the database, and also they can only view everything related to them (can view only their... -
i have actually solved the above, but i was wondering how u show just the current month in a query. I have tried to write date ().mm, and oders but they didnt work
is there a way just to place the currnt month on queries.Leave a comment:
No activity results to display
Leave a comment: