Home » Access » Page 2
DAO Help
Access
I am having trouble with the below returning the correct number of records, and can't see why.
I have one table, tblDevice, which has 4 columns, ID | DeviceRecNo | ExcludeFromCheck | StockLocationID
ID - Autonumber
DeviceRecNo - Number
ExcludeFromCheck - Number (1 = yes, 0 - No)
StockLocationID - Number
I have the following running as part of some code, but it is

General Date Format: Missing Time
Access
I have set a field on my FORM with the General Date format. Every time I use the date picker it inserts the correct date with a time of 00:00? I even changed the format on my table to general date - still no luck
I don't understand why?

Form and subform, parent and children in a transaction
Access
I have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: http://www.access-programmers.co.uk/...d.php

access 2003 to vb.net and sql server
Access
I wrote a database in Access 2003 which is shared between about 15 to 20 users. i.e they have similar front ends but all access the same back end mdb
Now my company are wanting to move the back end to sql server but have the front end in VB.NET and not Access. I guess you cannot do a simple conversion so the whole front end will have to be written in VB.NET. I am not doing this but

Why am I getting two PF & not one PF or FK using DeZign
Access
Hi I am still learning this ERD stuff and am trying out DeZign for a MSSQL database and I thought I had PK and FK all figured out now im am reading about PF and trying to understand.
Reading about identifying I thought the CL_Address table should just have the "PK clAddressID" and "PF clClientID" as the Primary Key. Why is it adding the other PF key ??
EDIT: oka

Leading zeros :
Access
I have an alphanumeric primary key that goes
REF0001
REF0002
REF0003
e.t.c.
When i get to REF9999 and enter REF10000 it does not store it after
REF9999 but stores it after REF100. Why is this ?
Is there a quick way that i can add leading 0's onto my records
so it will read
REF000001
REF000002
REF000003
e.t.c

Select query returning the string instead of the value
Access
Why is strCreditCheck returning the actual query string and not the result? Of course, this is not working. Please help.
Code:
Private Sub b_PrintWorkOrder_Click()
    Me.Requery
    Dim strCreditCheck A

Functional keys to perform commands
Access
Hi all.
Could some one tell me that can we use functional keys F1, F2,F3,,,,,,,,,,,,,,F12 in ms access to perform commands like saving a form data , for closing form refreshing form, clear form.
Or is there any way to make shortcut keys combination like[(ctrl+s)(ctrl+c) (ctrl+A)] in access to perform action like saving,closing,clearing, current form.

How to get a current user from a custom login form
Access
Hi friends, can some one like to tell me that how i can get a current user from a custom login form CurrentUser() this function always return a system user name admin as default. In my login schema i have a Hidden splash form that have a unbound field that holds user name from custom login form after login a dashboard execute and also display user name on dashboard according to user login

Also Filtering using a check box
Access
So I'm trying to figure out how to filter a report using a check box.
I have created a form, which if you push an industry labled button on that form it will show you the report with what work was done for that industry.
Now I'm trying to modify it so that I have a group of check boxes; each check box being a different office location the company has.
What I want to make happ

Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .