mose Mbugua
Last Activity: Jun 5 '15, 08:36 AM
Joined: Aug 12 '14
Location: Kiambu County, Kenya
-
i would like it to be called from vba but i don't know how to do it. am a newbie to code. which field on the control's property sheet should i type the code? -
Autonumber Using alphanumeric (text and number) data type
How can i generate the next available record number to appear in the primary key field on a data entry form?
For example, i want to add (admit) a new student but the primary key "Admission Number" has both text and numbers (C001).
When i open the Admission form i wish it to look at the last admission number record, add 1 to it, then prepopulate the id field -
mose Mbugua replied to Feeding updates from a newer database version (1.1) to an older version (1.0)in AccessTwinnyfo,
i will appreciate that alot.Leave a comment:
-
mose Mbugua started a topic Feeding updates from a newer database version (1.1) to an older version (1.0)in AccessFeeding updates from a newer database version (1.1) to an older version (1.0)
Hi Guys?. When using a program for example an Antivirus, there comes a time when it "tells" you that there is a newer version available. You then decide either to update it or not. Now my question is if that applies to access databases. Lets say after releasing a version of a database, say version 1.0, you then continue adding new features and debugging it. So you call the newer version 1.1. When you want those changes to appear in previous... -
Using values from a subreport in the main report
I have made a report from a query and added a sub report created from a different query. The main query has a calculated field so is the sub report. i want to subtract the totals in the sub report from the totals in the main report. Is there a way to doing this? -
Am new to code guys. Guide me to doing that.Leave a comment:
-
twinnyfo
what if we reduce that so that the report can only capture only forms and reports which were opened by a user? Do i have to use code or is there another way?Leave a comment:
-
Making a user logfile in acess 2007
Am trying to make an access report which will capture how a user after entering their username and password use system forms in a database. the report should show all the activities that took place after the user logged in. It should also show the time.
How do i go about that in access 2007?
Thanks -
i'm trying to make a username and password form in access 2007. After keeing in the below code, an error message showing "Method or data member not found" what might be the cause?a yellow highlight appears on line 1
...Code:Private Sub Command4_Click() Username.SetFocus If Username = "staff1" And Password = "staff1" Then MsgBox "Access Granted", vbInformation, "school system"
Leave a comment:
-
Method or data member not found error
I'm trying to make a username and password form in access 2007. After keeing in the below code, an error message showing "Method or data member not found" what might be the cause?
...Code:Private Sub Command5_Click() Username.SetFocus If Username = "staff1" And Password = "staff1" Then MsgBox "Access granted", vbInformation, "school system2" MsgBox "Welcome",
-
twinnyfo
i used your idea but the reply was an error message (#name). I can be a good student if you show me how!!Leave a comment:
-
i did. For now. until i find out another easier way to solve that. i ran a select query then used report wizard to display the info.. Thanks for your help.Leave a comment:
-
Zmbd:
i used a select query and it worked for me.Leave a comment:
-
Hi twinnyfo, i dont know how to do that. i'm a student and don't know how to use a text string to identify the file name.
am sure you can help on that.Leave a comment:
-
Make table query with a photo attached
Am trying to design a make table query from a table which has a photo attached to it. when i click on the run icon, an error message reading "Multi-valued fields are not allowed in SELECT INTO statements". what could be the casuse and how do i solve that? Thanks. -
the subform contains the passport of the student. i wanted both the passsport and student's merit to display at in one from since the passport is in the admision form (adm form) and the student merit is in another form (students merit form). i have tried a query but the passport does not show.Leave a comment:
-
Setting a printable area in access 2007
I have added a subform to a another form in my access project. the problem comes when printing. Am trying to print a specific form for a student but the form appears bit by bit in so many pages.i have tried using the print button but there is no change. is there a way that you can specify an area of a form that you want to print?
No activity results to display
Leave a comment: